Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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!
Thanks Amit , it's working