topic Re: last 4 weeks calculation in QlikView

last 4 weeks calculation

Anonymous — Tue, 06 Sep 2016 10:52:24 GMT

Hi All,

RangeAvg (
aggr( sum({<Year = {$(=vCurrentYear)},Week ={">= $(=vCurrentWeek-4)<= $(=vCurrentWeek-1)"}>} TRX_NET_SALES), WeekStart,ITEM_SKU))

Issue: the above condition works fine until current week is not one what if its one then it will return -3, 0

So we have to write an expression where it will work fine even though the current week is one and also it should work well even wen an year is having 52 weeks or leap year 53 weeks, so please write an expression accordingly.

example:if we are in 2016 first week it should also calculate 52,51,50,49 like that

can you please help me on this

Regards,

Devendar

Re: last 4 weeks calculation

maxgro — Tue, 06 Sep 2016 11:25:36 GMT

maybe adding a week serial field,

Re: select data of last 4 weeks.

Re: last 4 weeks calculation

Anonymous — Tue, 06 Sep 2016 11:57:58 GMT

Did you check this?

last 7 days and last 4 weeks data | Qlik Community

select data of last 4 weeks. | Qlik Community

https://community.qlikview.com/thread/194077

Re: last 4 weeks calculation

Jason_Michaelides — Tue, 06 Sep 2016 12:36:30 GMT

Look at Richard Pearce's document on calendar with flags. Much easier to create any comparative date period.

https://community.qlik.com/docs/DOC-6593

Hope this helps,

Jason