topic Need to create a where condition in variable. in QlikView

Need to create a where condition in variable.

Wed, 21 Oct 2009 17:16:07 GMT

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.

Need to create a where condition in variable.

Wed, 21 Oct 2009 18:16:37 GMT

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

Need to create a where condition in variable.

Wed, 21 Oct 2009 19:06:08 GMT

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!

Need to create a where condition in variable.

Wed, 21 Oct 2009 19:06:38 GMT

Thanks Amit , it's working