Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team ,
I have small doubt in accomplishing a one task .
I have my table structure in a DB as below
Plant | week | Supply | Demand |
A | 1 | 100 | 50 |
2 | 25 | 30 | |
3 | 12 | 100 | |
4 | 45 | 300 |
I need my table structure in qlik sense as
Weeks | |||||
Plant | Value | 1 | 2 | 3 | 4 |
A | Supply | 100 | 25 | 12 | 45 |
DEMAND | 50 | 30 | 100 | 300 |
Basically i would like to transpose column header as rows and column values as measure .
Thanks,
Anuradha
Check this out!
Fei