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