Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Thanks in advance of any support on this.
I would like to make a straight table in Sense which lists all weeks and has various measures in comparison
As per below:
This Week,
Last Week
Last 3 Weeks
Same week last year.
I have tried using set analysis but have no joy - it seems to only give me one value in each volume which is obviously not right.
Many thanks
Week | Sum | Last Week | Rolling 3 weeks | Same week last year |
---|---|---|---|---|
1 | ||||
2 | ||||
3 | ||||
4 | ||||
5 |
HI,
look here https://www.resultdata.com/qlik-custom-calendars/
I think this is what you need. Or at least a great idea.
Regards,
Andrey
To do this i think the best way is to use master calendar flags in your expressions.
Look at these two links:
Take a look at this thread, it will help you:
Now, for your case, it would be a table as follow:
1) Dimension : Week
2) Measure : sum(kpi)
3)Last week : above(sum(kpi))
4)Rolling 3 weeks: rangesum( above(sum(kpi),0,3))
5)Same week last year: //I suppose you have date, week, month year fields
sum({<date=,year=,[Year of date]={"$(=max(year)-1)"}
>}kpi)