1 Reply Latest reply: Dec 4, 2017 11:54 AM by omar bensalem RSS

    Transpose a table

    ra ta

      this might be easy and i am still new to qlik.

       

      My table in the database looks like this:

       

      productyearsales
      product1201410
      product2201420
      product3201430
      product12015110
      product22015120
      product32015130
      product12016210
      product22016220
      product32016230

       

       

      I am trying to use qlik sense to display data in the following format:

       

      product     2014     2015       2016
      product110110210
      product220120220
      product330130230

       

      For each year column, i have tried =if(Year = '2014', Product, null()), but this is not working.

       

      Much appreciated.

       

      Thanks and regards,

      Ra