Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!.
You don't have to post the questions twice.