Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
geogou1973
Creator
Creator

Problem with pivot table in the expression above

Hello i have a problem with the following expression in the pivot table.

When i expand to the field ITEM the following expression does not work

SUM({$<CATEGORY_MOVEMENT={'INV'}>} QTY_MOVES) - ABOVE(SUM({$<CATEGORY_MOVEMENT={'INV'}>} QTY_MOVES))

When i collapse into STORE and DATE works

In  the expression INVENTORY QTY i have the expression SUM({$<CATEGORY_MOVEMENT={'INV'}>} QTY_MOVES)

Can anyone help me with this issue ?

Thank you in advance.

 

geogou1973_0-1625576054881.png

geogou1973_1-1625576084611.png

 

1 Reply
geogou1973
Creator
Creator
Author

I found the solution.

I have to write the following expression

SUM({$<CATEGORY_MOVEMENT={'INV'}>} QTY_MOVES) - ABOVE(TOTAL SUM({$<CATEGORY_MOVEMENT={'INV'}>} QTY_MOVES))