Yearly WoW Comparison not working with set analysis

[#1]

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

[ahaahaaha]

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

[micheledenardi]

To do this i think the best way is to use master calendar flags in your expressions.

Look at these two links:

Creating A Master Calendar

Calendar fixed start date

[OmarBenSalem]

Take a look at this thread, it will help you:

YTD, MTD issue

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)