Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a data set like this:
Store | Item | On Hand |
---|---|---|
A | 1 | 50,000 |
A | 2 | 20,000 |
A | 3 | 10,000 |
B | 1 | 90,000 |
B | 2 | 95,000 |
C | 1 | 500,000 |
C | 2 | 5,000,000 |
C | 3 | 90,000 |
C | 4 | 950,000 |
I need to create a chart in Qlik Sense Desktop which will show this:
Store | Item 1 | Item 2 | Item 3 | Item 4 | |
---|---|---|---|---|---|
A | 50,000 | 20,000 |
| 0 | |
B | 90,000 | 95,000 | 0 | 0 |
I guess its a simple pivot... i'm just coming up blank at the moment.
You should be able to sort it with the Out Of the Box Qlik Sense Pivot Table.
Just use a pivot table;
as dimension: Store
As measure: sum("On Hand")
then add a column: Item