1 Reply Latest reply: Jun 26, 2013 12:22 PM by Ursino Giuseppe RSS

    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