4 Replies Latest reply: Jun 23, 2014 11:54 AM by Ramkumar Ramagopalan RSS

    How to Convert Columns into rows in qlikview backend side ? Transpose Rotate ?

      HI,

       

      I am new to qlikview.

       

      I really need help and suggestions for this below.

       

      i would like to convert column  data into row.

       

      example :

       

      Field Key

      100    1

      200     2

      300     3

      400     4

      500   5    <--this data are not fixed. this are the precalculated numbers in another table and i would like to referece those afte rbelow transpose. I have came across other people suggested Inline functionality, but, i believed, that will work if data are static.

      so, can please someone suggest any solutions ?

       

      output :

       

      1        2          3       4       5  <--key will become columns 1 to 5 and data from field above will shows as data under each columns.

      100    200    300   400   500

       

      can someone please help me ?

       

      Thanks!.