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: 
qlikconsultant
Creator II
Creator II

Show only the negativ values in a pivot table

Hi,

I have this formel in a table with 3  dimesions.

if(sum(A)+sum(B)<0,
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
marcus_sommer
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