Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need to create a where condition in variable.

Hi All,

I am new to qlikview.

I have data object contains dates and day objects contain monday, thuesday to sunday for each date.

now i would like to create a graph showing all mondays date on x axis and revenue on y axis ( i don't want to use list box for days as it filter other tables and graph on tabs which is not required)

so i want create a object/varaible which show dates for monday ( like Date where day = 'monday' ) . Coiuld you please tell how can i create this qlikview.

3 Replies
Not applicable
Author

Hi,

You can either create a new field in the script using code if(day = 'monday',date) and use this field in the chart or you can create a calculated dimension in the chart using same code. Check the option 'Suppress when value is null' in chart properties.

Hope this helps.

Thanks

Amit

Not applicable
Author

Try using a set. The expression would look something like this:

sum ({<Day={'Monday'}>}Revenue)

As long as you use No Accumulation it should show all dates seperately.

Hope this works!



Not applicable
Author

Thanks Amit , it's working