topic Re: previous 13 weeks of data in QlikView

previous 13 weeks of data

Tue, 24 Feb 2015 10:48:39 GMT

Dear Community,

I'm trying to display a graph that has weeks as the dimension - the graph should only ever show 13 weeks of data regardless of the selections made (based on the maximum date value)

I've set up the appropriate variables and set analysis so that the correct date range is captured, however the order of my week dimension seems to be completely random. I'm not sure what sorting expression i can include to display the weeks correctly?

Sorting on the numeric value of the week works best but does not work when week 5 is selected (as the previous 13 weeks include week 52 from the previous year.

Below are some screen shots:

Sorting by numeric value

Sorting by Date

Please help!!

Re: previous 13 weeks of data

yura_ratu — Tue, 24 Feb 2015 12:15:34 GMT

Please attach an example. There are several ways to achieve it, depending from your data

Re: previous 13 weeks of data

Tue, 24 Feb 2015 15:47:06 GMT

Sorry - attached is an example

Re: previous 13 weeks of data

yura_ratu — Wed, 25 Feb 2015 11:48:20 GMT

Hi Drew

Little change on Sort tab.

Also i did a little change for Min date variable calculation. Your was correct, however the first week on your graph always will be not complete and useless to compare with the next one. Use it on your own judgment

Re: previous 13 weeks of data

Wed, 25 Feb 2015 12:08:27 GMT

Hi Yuriy,

Thank you very much for your help but I'm afraid you are encountering the same issue as me - if, on your example, you select 2015 as the year. The "2014" data which is shown due to the set analysis displays as 49, 52, 50, 51.....

This is the issue i am encountering!

Many thanks,

Drew

Re: previous 13 weeks of data

yura_ratu — Wed, 25 Feb 2015 12:45:20 GMT

Try again. Copied your set analysis from expression to sorting function. Should work

Re: previous 13 weeks of data

Wed, 25 Feb 2015 14:32:09 GMT

PERFECT!!!!!!!!!!!!!