Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Issue in generating Rolling weekly reports.

Hi All,

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

Below is an example data

MonthWeek StartNext weekLast week6 weeksQuarter to dateWeekly Count6 weeks Count

Quarter

To Date

Count

16-Jul7/4/20167/11/20166/27/20165/30/20167/1/20161101
16-Jun6/27/20167/4/20166/20/20165/23/20164/1/201621331
16-Jun6/20/20166/27/20166/13/20165/16/20164/1/201611629
16-Jun6/13/20166/20/20166/6/20165/9/20164/1/201631628
16-Jun6/6/20166/13/20165/30/20165/2/20164/1/201611525
16-May5/30/20166/6/20165/23/20164/25/20164/1/201621824
16-May5/23/20165/30/20165/16/20164/18/20164/1/201641722
16-May5/16/20165/23/20165/9/20164/11/20164/1/201651518
16-May5/9/20165/16/20165/2/20164/4/20164/1/201611313
16-May5/2/20165/9/20164/25/20163/28/20164/1/201621312
16-Apr4/25/20165/2/20164/18/20163/21/20164/1/201641610
16-Apr4/18/20164/25/20164/11/20163/14/20164/1/20161126
16-Apr4/11/20164/18/20164/4/20163/7/20164/1/20162115
16-Apr4/4/20164/11/20163/28/20162/29/20164/1/2016393
16-Mar3/28/20164/4/20163/21/20162/22/20161/1/2016166
16-Mar3/21/20163/28/20163/14/20162/15/20161/1/2016555

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:

         

     

MonthWeek StartWeekly Count6 weeks CountQuarter To Date Count
16-Jul7/4/20161101
16-Jun6/27/201621331
16-Jun6/20/201611629
16-Jun6/13/201631628
16-Jun6/6/201611525
16-May5/30/201621824
16-May5/23/201641722
16-May5/16/201651518
16-May5/9/201611313
16-May5/2/201621312
16-Apr4/25/201641610
16-Apr4/18/20161126
16-Apr4/11/20162115
16-Apr4/4/2016393
16-Mar3/28/2016166
16-Mar3/21/2016555

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

5 Replies

Re: Issue in generating Rolling weekly reports.

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

Not applicable

Re: Issue in generating Rolling weekly reports.

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.

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

Not applicable

Re: Issue in generating Rolling weekly reports.

Hi,

I've attached the sample app.

Not applicable

Re: Issue in generating Rolling weekly reports.

Hi All,

Can anyone please help me in this....

Thanks..