Need to create a where condition in variable.

[#1]

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.

[#2]

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

[#3]

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!

[#4]

Thanks Amit , it's working