Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

ursino
New Contributor

Comparing Dynamic Group of Quarters

Dear Expert,
I'm new with QlikView I really count on your  help.
I've following pivot:
Year20122012201220122012201320132013
VendorQuarter2012 012012 022012 032012 04Total2013 012013 02Total
AAA5555555577777777
BBB111122223333666622228888
CCC44444444333311114444
The pivot is based on Custom Calendar so it's not a "standard calendar" that cannot be elaborated using a "system date", so far I have a Custom Calendar dimension.
However I do have to obtain a different table, grouping the Quarter indipendently from the year  and based on following rule:
Considering a Starting Quarter, i.e.:   2013 02 
I have to group by Number of Quarter (i.e. default = 4 ) and decide how may groups to compare for instance 3 groups, so to have:
Quarter_Group_1 = 2013 02 - 2013 01 - 2012 04 - 2012 03
Quarter_Group_2 = 2012 02  - 2012 01 - 2011 04 - 2011 03
Quarter_Group_3 = 2011 02  - 2011 01 - 2010 04 - 2010 03
Other example in case "Number of Quarters to group = 2" and "groups to compare = 2" and "Starting Quarter = 2013 03"

Quarter_Group_1 = 2013 03  - 2013 02

Quarter_Group_2 = 2013 01  - 2012 04

Can you help, I'm stacked on it.

Thanks

Giuseppe

1 Reply
ursino
New Contributor

Re: Comparing Dynamic Group of Quarters

Hello,

Someone can help?

Rgds,

Giuseppe

Community Browser