Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

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: 
guy_benhaim
Contributor
Contributor

Conditional Summation of Pivot Rows

Hello,

I have a pivot table with 3 dimensions, in which I would like to sum the "Dist" expression only for the rows that have "1" in their "load" expression in the row below. I did not manage to do it properly, such that if I collapse summation works.

        Aggr ... , TOTAL ..., Below() ....

The lowest dimension is sorted, and "below" is determined by sorting.

Please advise.

temp.PNG

Best

5 Replies
Jesh19
Creator II
Creator II


Below Expression might work


Sum(If(Load(Pre)=1, Dist))

guy_benhaim
Contributor
Contributor
Author

Does not recognize the operator "Pre".

Did you test this?

Jesh19
Creator II
Creator II

As per your screenshot, i considered it to be a field in your model.

guy_benhaim
Contributor
Contributor
Author

Ah ... that's the label. The field is "Load".

But, the condition should be that Load=1 in the row below the row whose "Dist" we are summing.

guy_benhaim
Contributor
Contributor
Author

This works, per line:  If(Below(Load)=1 or Below(Load)=0,Sum(Dist),0)

But when I collapse the dimension it sums to 0 ...