Discussion Board for collaboration on QlikView Scripting.
I wanted to generate report based on Weekly, 6 Weeks, and Quaterly
Below is an example data
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:
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
this link would be helpful.. Set Analysis for Rolling Periods
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'.
Could you provide the sample qvw which is not working for you with the master calendar ?
I've attached the sample app.
Can anyone please help me in this....