12 Replies Latest reply: Mar 24, 2017 1:00 PM by Akpofure Enughwure RSS

    How to interswitch dimension and measure

    Akpofure Enughwure

      Hello there,

       

      I have a set of data in this format.

       

      CompanyYEARMONTHLTIUACOSNMFI
      JohnLee2016January1561243
      BarryHouses2016October04044
      Choi and Sons2016December1340451

       

      after the loading the data into my qliksense app, the data looks like this:

       

      LOAD *,

      if( Isnum(Date), 'Q')& Ceil(Month(Date)/3) as Quarter;

       

      LOAD *,

          

          Date(Date#(Year&Month, 'YYYYMMMM')) as Date;

      LOAD Company

              "YEAR"as Year,

          "MONTH" as Month,

          FAT,

          LTI,

          RTA,

          UA,

          UC,

          NM,

      XXXXXXXXXX

       

      With this, I can easily build a visualization, using Company, Year, Quarter  and Month  as dimension and LTI, UAC, OS as measures.(picture 1)

       

      The clients wants the reverse (LTI, UAC, OS as dimension and Quarter measure) (picture HSI)

       

      See attached for clarification