Issue in generating Rolling weekly reports.

Tue, 12 Jul 2016 14:02:03 GMT

Hi All,

I wanted to generate report based on Weekly, 6 Weeks, and Quaterly

Below is an example data

Month	Week Start	Next week	Last week	6 weeks	Quarter to date	Weekly Count	6 weeks Count	Quarter To Date Count
16-Jul	7/4/2016	7/11/2016	6/27/2016	5/30/2016	7/1/2016	1	10	1
16-Jun	6/27/2016	7/4/2016	6/20/2016	5/23/2016	4/1/2016	2	13	31
16-Jun	6/20/2016	6/27/2016	6/13/2016	5/16/2016	4/1/2016	1	16	29
16-Jun	6/13/2016	6/20/2016	6/6/2016	5/9/2016	4/1/2016	3	16	28
16-Jun	6/6/2016	6/13/2016	5/30/2016	5/2/2016	4/1/2016	1	15	25
16-May	5/30/2016	6/6/2016	5/23/2016	4/25/2016	4/1/2016	2	18	24
16-May	5/23/2016	5/30/2016	5/16/2016	4/18/2016	4/1/2016	4	17	22
16-May	5/16/2016	5/23/2016	5/9/2016	4/11/2016	4/1/2016	5	15	18
16-May	5/9/2016	5/16/2016	5/2/2016	4/4/2016	4/1/2016	1	13	13
16-May	5/2/2016	5/9/2016	4/25/2016	3/28/2016	4/1/2016	2	13	12
16-Apr	4/25/2016	5/2/2016	4/18/2016	3/21/2016	4/1/2016	4	16	10
16-Apr	4/18/2016	4/25/2016	4/11/2016	3/14/2016	4/1/2016	1	12	6
16-Apr	4/11/2016	4/18/2016	4/4/2016	3/7/2016	4/1/2016	2	11	5
16-Apr	4/4/2016	4/11/2016	3/28/2016	2/29/2016	4/1/2016	3	9	3
16-Mar	3/28/2016	4/4/2016	3/21/2016	2/22/2016	1/1/2016	1	6	6
16-Mar	3/21/2016	3/28/2016	3/14/2016	2/15/2016	1/1/2016	5	5	5

The Weekly Count is sum(Counts) dates between Week Start column and Less than Next Week column

The 6 Weekly Count is sum of counts dates between the 6 Weeks column and less than Next Week Column

The Quarter To Date Count is sum of counts dates between the Quarter to date column and less than Next Week Column

The report in qlikview should be as follows:

Month	Week Start	Weekly Count	6 weeks Count	Quarter To Date Count
16-Jul	7/4/2016	1	10	1
16-Jun	6/27/2016	2	13	31
16-Jun	6/20/2016	1	16	29
16-Jun	6/13/2016	3	16	28
16-Jun	6/6/2016	1	15	25
16-May	5/30/2016	2	18	24
16-May	5/23/2016	4	17	22
16-May	5/16/2016	5	15	18
16-May	5/9/2016	1	13	13
16-May	5/2/2016	2	13	12
16-Apr	4/25/2016	4	16	10
16-Apr	4/18/2016	1	12	6
16-Apr	4/11/2016	2	11	5
16-Apr	4/4/2016	3	9	3
16-Mar	3/28/2016	1	6	6
16-Mar	3/21/2016	5	5	5

Can you help how can I show the weekly,6 weekly and quarter to date report in one chart.

help me with the expression to use.

I am using the master calendar with flags V1.5 https://community.qlik.com/docs/DOC-13536

richard.pearce‌

Re: Issue in generating Rolling weekly reports.

settu_periasamy — Tue, 12 Jul 2016 19:44:40 GMT

this link would be helpful.. Set Analysis for Rolling Periods

Re: Issue in generating Rolling weekly reports.

Wed, 13 Jul 2016 05:52:11 GMT

Thanks for the response.

I already tried giving expression from the mentioned link.

Just to add here, I'm using the master calendar with Flags (MTD,WTD,QTD,YTD) which was developed by Richard Pearce, not sure why it is not working in this scenario.

Wanted to know what is that I'm missing. Since our Dimension should be 'Year-Mon' and 'WeekStart'.

Re: Issue in generating Rolling weekly reports.

settu_periasamy — Wed, 13 Jul 2016 06:02:34 GMT

Could you provide the sample qvw which is not working for you with the master calendar ?

Re: Issue in generating Rolling weekly reports.

Wed, 13 Jul 2016 09:48:38 GMT

Hi,

I've attached the sample app.

Re: Issue in generating Rolling weekly reports.

Tue, 19 Jul 2016 13:18:30 GMT

Hi All,

Can anyone please help me in this....

Thanks..

topic Re: Issue in generating Rolling weekly reports. in QlikView

Issue in generating Rolling weekly reports.

Re: Issue in generating Rolling weekly reports.

Re: Issue in generating Rolling weekly reports.

Re: Issue in generating Rolling weekly reports.

Re: Issue in generating Rolling weekly reports.

Re: Issue in generating Rolling weekly reports.