5 Replies Latest reply: Oct 10, 2012 8:54 AM by Baru - RSS

    Pivot table....

      Hello All,

       

      I have a dought in pivot table.

      Let me explain, i have a dimensions are

      1)Zone

      2)Region

      3)District

      4)Territory

      it is all from one table...

       

      I know, in qlikview we can create a pivot table like this:

       

       

      But,I want to look like this report in qlikview is:

      dimensionsalestarget
      South(zone)

      KNA(Region)

      Ban(district)

      hol(territory)

      hos(territory)

      Mang(district)

      jie(territory)

      nejk(territory)

      TN(Region)

      Chen(District)

      pon(territory)

      bje(territory)

      Kan(district)

      civ(territory)

      ehio(territory)

      KER(Region)

      Koch(district)

      bnajs(territory)

      kott(territory)

      Trin(district)

      njew(territory)

      jewq(territory)

      APS(Region)

      Cht(district)

      qiore(territory)

      njke(territory)

      Cud(district)

      njwqd(territory)

      notew(territory)

      is it possible to call 4 dimnsion as a one dimension in pivot table hierarchy which i mensioned in the above.

      Please share me your ideas about this.

      I am attaching my sample application(pfa).

       

       

      regrds,

      baru