How to Convert Columns into rows in qlikview backend side ? Transpose Rotate ?
I am new to qlikview.
I really need help and suggestions for this below.
i would like to convert column data into row.
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 ?
1 2 3 4 5 <--key will become columns 1 to 5 and data from field above will shows as data under each columns.