topic Re: Rolling 52 Weeks Chart in QlikView

Rolling 52 Weeks Chart

spikenaylor1 — Wed, 25 Nov 2020 16:16:04 GMT

My script Load dimension is:

calcs:

Load *,

MonthName([Date Document Final Approved]) as Month,

YearName([Date Document Final Approved]) as Year,

WeekEnd([Date Document Final Approved]) as weekend,

Resident main;

Drop table main;

My chart dimension is:

weekend

My chart expression is

=num(sum({1}RFT)/Count({1}RFT),'#.##%')

been asked now to display the chart as a rolling 52 weeks chart

Tried a few options I have found but not able to get to work

any pointers or guidance please

Many thanks for looking and helping

Re: Rolling 52 Weeks Chart

vinieme12 — Fri, 21 Apr 2017 08:43:51 GMT

Create a WeekNumber field

then you can restrict to latest 52 weeks as

WeekNum >= Max(WeekNum)-52 <=Max(WeekNum)

See the attached

Re: Rolling 52 Weeks Chart

Kushal_Chawda — Fri, 21 Apr 2017 10:22:10 GMT

may be below expression

num(sum({1<[Date Document Final Approved]={">=$(=date(max([Date Document Final Approved])-357))<=$(=date(max([Date Document Final Approved])))"}>}RFT)/Count({1<[Date Document Final Approved]={">=$(=date(max([Date Document Final Approved])-357))<=$(=date(max([Date Document Final Approved])))"}>}RFT),'#.##%')

Re: Rolling 52 Weeks Chart

jurriejoachim — Fri, 22 Dec 2017 14:58:04 GMT

Hi Mike,

It took me al while to find "weeks ago " that worked with the end of a year. Like datediff in SQL. But if you put this in your script you got rolling weeks ago that even work in January.

((weekname(Today())) - (weekname([datum])))/7 as WeeksAgo,

And in my object I use

=if(MixMatch(WeeksAgo,'1','2','3','4','5')>0,Verzoeken.Year_Week,Null())

and supress when value is Null

best regards Jurrie