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