Comparing Dynamic Group of Quarters

[Anonymous]

Dear Expert,

I'm new with QlikView I really count on your  help.

I've following pivot:

	Year	2012	2012	2012	2012	2012	2013	2013	2013
Vendor	Quarter	2012 01	2012 02	2012 03	2012 04	Total	2013 01	2013 02	Total
AAA				5555		5555		7777	7777
BBB		1111			2222	3333	6666	2222	8888
CCC		4444				4444	3333	1111	4444

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

[Anonymous]

Hello,

Someone can help?

Rgds,

Giuseppe