Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

week-year comparison over 3 years

Hi

I need to create a line chart that has a week-year dimension and calculates the yoy % growth at each point.

I have data that spans 3 years, so i'm struggling to use set analysis to do this.

any suggestions?

i.e at wk1 2016 growth from wk1 2015, at wk1 2017 growth from wk1 2016 etc

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: week-year comparison over 3 years

Hi Sunny

After chatting to a colleague about AsOf that is the solution I've used.

I've combined the year and week and used AsOf to add a CW and PW (current and previous week) to my calendar.

This has allowed me to write my expression;

= (sum({<Group={'One'},WeekType={'CW'}>}Customers)

- sum({<Group={'One'},WeekType={'PW'}>}Customer))

/ sum({<Group={'One'},WeekType={'PW'}>}Customer)

plotting against the dimension AsOfYearWeek

5 Replies

Re: week-year comparison over 3 years

You can consider using the The As-Of Table‌ approach

Not applicable

Re: week-year comparison over 3 years

Thanks Sunny, I've used asof before but to get a cumulative value where using the cumulative tick box doesn't work with distinct values on a chart.

I'm not quite clear how I could use it here though.

I'd like my line chart/straight table to show for the week year as a dimension so for 012016 the % YOY difference to only 012015 not the full year between those dates. The 2nd marker 022016  sowing YOY difference to 022015 etc.

I can't figure out how to write the expression even using variables so end up with two years worth of data on my chart.

thank you for your reply, apologies if i'm missing the obvious!

Re: week-year comparison over 3 years

I won't understand the whole scenario unless I see a sample. Would you be able to share a sample to show what you have and may be we can offer a better suggestion?

Highlighted
Not applicable

Re: week-year comparison over 3 years

Hi Sunny

After chatting to a colleague about AsOf that is the solution I've used.

I've combined the year and week and used AsOf to add a CW and PW (current and previous week) to my calendar.

This has allowed me to write my expression;

= (sum({<Group={'One'},WeekType={'CW'}>}Customers)

- sum({<Group={'One'},WeekType={'PW'}>}Customer))

/ sum({<Group={'One'},WeekType={'PW'}>}Customer)

plotting against the dimension AsOfYearWeek

Re: week-year comparison over 3 years

Awesome!!!

I am glad you managed to figure it out . I would request you to close this thread by marking your own response as the correct response.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny

Community Browser