Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

Show only the negativ values in a pivot table


I have this formel in a table with 3  dimesions.

sum(A) + sum(B), 0)

It works in a table but I have to change in a pivote table. 

The some values are missing because the total is poitiv any tips how can I fix that.


1 Reply
MVP & Luminary
MVP & Luminary

The following should work better as your approach but it may not prevent all NULL returns if data are missing:

rangemin(rangesum(sum(A), sum(B)), 0)

- Marcus