New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New 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.

Best

5 Replies
Contributor II

Re: Conditional Summation of Pivot Rows

Below Expression might work

New Contributor

Re: Conditional Summation of Pivot Rows

Does not recognize the operator "Pre".

Did you test this?

Contributor II

Re: Conditional Summation of Pivot Rows

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

New Contributor

Re: Conditional Summation of Pivot Rows

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.

New Contributor