Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Yearly WoW Comparison not working with set analysis

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

 

WeekSumLast WeekRolling 3 weeksSame week last year
1
2
3
4
5
3 Replies
ahaahaaha
Honored Contributor

Re: Yearly WoW Comparison not working with set analysis

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
Valued Contributor

Re: Yearly WoW Comparison not working with set analysis

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

Partner
Partner

Re: Yearly WoW Comparison not working with set analysis

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)