1 Reply Latest reply: Apr 25, 2018 8:46 AM by Sunny Talwar RSS

    Converting measure into dimension in Qlik sense

    Vinay Vishwanatha

      Hi All,

       

      I have data given in below format, wherein it is monthly forecast from P1 (Jan) to P12 (Dec) and need to represent the same in Qlik sense Period wise P1, P2 ...... as chart shown below (excel charts as a reference)

      Monthly forecast
      P1P2P3P4P5P6P7P8P9P10P11P12
      488455.8440029441172.8441626.4450544.8456014.9380620.5438305461611.9476927.7461611.9438305
      746558.21465887656513.9912060.31062828902009.1771343.8932162.7922111.51153289992469.7992469.7

       

      Capture.PNG