topic Re: How to calculate last four weeks data? in QlikView

How to calculate last four weeks data?

varunreddy — Fri, 08 Jun 2018 18:55:39 GMT

Hi All,

I am trying to calculate last four weeks data.

I have a date field and latest date available is 5/27/2018 and minimum date is 1/12/2017.

I converted the date filed into Year and Week format.

So max week is 5/27/2018 (i.e. Week22) Format - 2018-W22

Min Week - 1/12/2017 (i.e. Week52) Format - 2017-W52

Now I want to show last four weeks data. this is the order of last four weeks.

1. 5/27/2018 - W22 (2018-W22)

2. 5/20 - 5/26 - W21

3. 5/13 - 5/19 - W20

4. 5/6 - 5/12 - W19

Can someone help me in getting data for 4 weeks?

I am able to get max week using the formula:

=Max(Year([Created date])&Week([Created date])) - Output - 201822

I am trying to find the way to get W19 (201819)

mayankraoka — Fri, 08 Jun 2018 22:54:00 GMT

Just try

=Max(Year()&Week(),-4 )

Regards,

Mayank

varunreddy — Sun, 10 Jun 2018 01:14:23 GMT

Hi Mayank,

It is still giving the maximum year and week.

Regards,

Varun

mayankraoka — Mon, 11 Jun 2018 11:33:36 GMT

Please share your application here...So that i can look into it.

Regards,

Mayank

varunreddy — Tue, 12 Jun 2018 20:50:45 GMT

Hi Mayank,

Thanks for your response. I got it working. I calculated max date and then took weekend value as max value and then subtracted 28 days from it.

Cheers,

Varun