topic Sum of Rows in pivot table in QlikView

Sum of Rows in pivot table

djallelsadki — Wed, 08 Feb 2012 08:30:37 GMT

Hello,

I have a pivot table, with :

Three dimensions "X", "Y", "Z" and one expression wich calculates the sum of the field "H"

A variable "V" filled through a slider

In my expression i have

if (sum (H)> V, sum (H))

The problem is in the total

expression works well but the total does not change, I would like to have the sum of rows and not the expression total

see the attachment file

Thank you for your answers

Wed, 08 Feb 2012 08:47:08 GMT

Hi,

see your modified example.

Good luck!

Rainer

Sokkorn — Wed, 08 Feb 2012 08:50:34 GMT

Hi,

Try to change your expression from if(sum(H)>V,sum(H)) to SUM(if(H>V,H,0))

Hope this work.

Regards,

Sokkorn Cheav