I need to show a table in my qlikview dashboard , where , the current weeks values are compared with last weeks value . E.g. Monday this week and monday last week. I need to show it in the format displayed beloow. I tried using reangesum , But it breaks as soon as i get Week Start Date dimesion in the chart. Can someone please help here ?
Basically , I want to show measure of current week days and last week days against current week dates ..Check the values in bold. In week of 8/3/2014, on first day value was 10. This value should appear as previous week value on first day of week of 8/10/2014.
Using Date as the dimension your first expression would simply be:
Sum(Amount)
And as long as you are loading the dates with numerical values (ie 8/3/14 = 41706 etc) then your second expression would be Sum({<Date={$(=Only(Date)-7}>}Amount)
Then you could compare by using Column(2) - Column(1) in a 3rd expression
Yes, of course that won't work because the set analysis is looking at the selection not dimension (sorry). I think the best solution would be to load the values offset by a week and call the field something like AmountPrevWeek.
Then your second expression would just be Sum(AmountPrevWeek)
