Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a qlikview file with a normal calender and I am plotting an expression on each weekday. What I want to do is show the lastest whole week or the whole week that a date is selected from. At any point the chart should display all the weekdays even if a single date is selected. How do I generate calculated dimension such that it always display whole week in chart? (ignore the chart data for now it's there just to test)
Thanks,
Maulik
One way is a separate table of your day names, with an IF to match up to the real day names. That would normally be inefficient for large data sets, but since set analysis is limiting us to a week before applying the IF, I doubt it'll cause any performance problems. You'll still have the issue where selecting the day name in the chart won't really select the day name. You could fix that with actions or macros, but it may not be worth the trouble.