Qliksense: Dimensions and Conditional Set expressions

preview_player
Показать описание


#qliksense #dataviz #qlik

****************************************************************************
#qlik #qliksense #dataviz

0:00 Intro
1:30 Dimensions and Set Expression
2:00 Combining names and values

**********************************************************************
Struggling to get your work done? Check out:

📚 Read on Kindle the simplest way to become ultra-productive:

TikTok - @thinkmetrics

WHO AM I:
🙋🏻‍♂️ I'm Kaush, a Data Analyst and Data Visualization Developer working for a tech company. I live and work in Sweden. I make videos about technology, productivity, and lifestyle design. Say hi to me on Twitter 😃
Рекомендации по теме
Комментарии
Автор

@3:26 you're using " " for the entire filter, after using the " sign. The system takes the entire filter calculation as a string and then how it will work ??

knowwhoyouare
Автор

Great stuff! Thank you!
I have a requirement in which the business would like to filter a straight table by the conditional background color of a calculated field. I have created a variable called vColorfilter and used it in a variable input. I created 3 fixed values where red =1, yellow = 2, green = 3, all as buttons. I then navigated to the table's field background color conditional setting for the calculated field in question and used the variable and the if statements in a PICK(vColorfilter, if(value > 100, red(), if(value < 100, green, yellow()))). The colors are filtering accordingly. However, the rows which do not meet the color condition when I filter by each color are still shown. The business does not want to see these white rows. How can I have them filtered out? Kindly advise!

PS-vcef
Автор

You are cool, Bro. Great Channel really

udayk
Автор

Can u pls share some load script questions for interview preparation in a video series format..

anu
Автор

Sir, i watch your videos and it really helps me a lot but sir as I am fresher I am struggling with creating a data model in qlik sense.
Some time I really confused which is the dimension table and which is the fact table.
So could you please make the detail video for creating data model(..star schema or snow flake schema ) and thanks for creating such a great content. I hope you will make the video waiting for positive response.

aviralsrivastava