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