Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
crossroadsit
Contributor II
Contributor II

Pivot table showing quantity of each item type on hand at end of each month

Hello all. I have inventory data that includes some columns like this:

idtypequantityreceived_onsent_on
1A221-1-201715-2-2017
2B321-1-201720-3-2017
3B221-1-2017
4C121-1-201713-11-2017
5D321-1-2017

I want to produce a pivot table showing the quantity of each type of item on hand at the end of each month.

row: type

column: monthend of each month

measure: quantity in stock (i.e. sum quantity if the item was received before the column's monthend and was either never sent or was sent after that column's monthend)

I hope that makes some sense... any help appreciated.

0 Replies