Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot data in Qlik table

I have a data set like this:

StoreItemOn Hand
A150,000
A220,000
A310,000
B190,000
B295,000
C1500,000
C25,000,000
C390,000
C4950,000

I need to create a chart in Qlik Sense Desktop which will show this:

StoreItem 1Item 2Item 3Item 4
A50,00020,000
10,000
0
B90,00095,00000

I guess its a simple pivot... i'm just coming up blank at the moment.

2 Replies
Anonymous
Not applicable
Author

You should be able to sort it with the Out Of the Box Qlik Sense Pivot Table.

OmarBenSalem

Just use a pivot table;

as dimension: Store

As measure: sum("On Hand")

then add a column: Item