topic Re: Rolling Quarter to Quarter in QlikView

Rolling Quarter to Quarter

Fri, 12 Sep 2014 06:36:57 GMT

Now I'm a little bit of different requirement. I've the year(2011,2012 etc.) and its relevant quarters(1,2,3,4) is present in the raw data and I'm trying to calculate Quarter Year on Quater Year (QYoQY) calculation where if I select the year as 2013 Q2 then it should show me the data from 2013 Q1 to 2012 Q2.

Any Suggestion for this scenario.....

Thanks In advance.

Vignesh kumar,

Re: Rolling Quarter to Quarter

senpradip007 — Fri, 12 Sep 2014 06:56:46 GMT

vignesh Kumar wrote:

Now I'm a little bit of different requirement. I've the year(2011,2012 etc.) and its relevant quarters(1,2,3,4) is present in the raw data and I'm trying to calculate Quarter Year on Quater Year (QYoQY) calculation where if I select the year as 2013 Q2 then it should show me the data from 2013 Q1 to 2012 Q2.

Do you want data from 2013 Q1 to 2012 Q2 or 2013 Q1 to 2013 Q2 if you select 2013 Q2?

Re: Rolling Quarter to Quarter

Fri, 12 Sep 2014 07:00:20 GMT

If i select 2013 Q2 i need to display data for previous 4 Quarters like 2013 Q1, 2012 Q4 , 2012 Q3, 2012 Q2. Kindly give some ideas to resolve it.

Thanks in advance.

Regards,

Vignesh Kumar

Re: Rolling Quarter to Quarter

senpradip007 — Fri, 12 Sep 2014 07:06:24 GMT

You can try like:

Sum({<Date={">=$(=Date(AddYears(QuarterStart( Max(Date)), -1),'DD/MM/YYYY')) <=$(=Date(Max(Date)),'DD/MM/YYYY')"}>} [Your Field])