topic Re: Show Last 12 Weeks count in QlikView

Show Last 12 Weeks count

rajaqliks — Mon, 31 Dec 2018 10:01:58 GMT

Hi Qlik Experts,

I have to show last 12 weeks count, i am addding the sample application. and i am adding a picture what i need to show.

Re: Show Last 12 Weeks count

sunny_talwar — Mon, 31 Dec 2018 12:09:11 GMT

Try this expression

=Count(DISTINCT {<Weekend = {"$(='>=' & Date(Max(Weekend) - 77, 'MM/DD/YYYY') & '<=' & Date(Max(Weekend), 'DD/MM/YYYY'))"}>} Key)

Re: Show Last 12 Weeks count

rajaqliks — Mon, 31 Dec 2018 13:30:14 GMT

Thank you so much sunny, and can you please explain why you are using 77.

Re: Show Last 12 Weeks count

sunny_talwar — Mon, 31 Dec 2018 13:34:34 GMT

77 is going back 11 weeks... so, because we are including the current week and considering it as 0, we are going back 11 weeks to make a total of 12 weeks.

Re: Show Last 12 Weeks count

rajaqliks — Mon, 31 Dec 2018 14:17:59 GMT

Ok sunny now its clear, thank you very much sunny really helpful your support

Re: Show Last 12 Weeks count

rajaqliks — Mon, 31 Dec 2018 14:20:44 GMT

In a year we have only 54 weeks right, then wt is 77