topic pivot expression total in QlikView

pivot expression total

ilanbaruch — Sat, 16 Nov 2024 17:42:45 GMT

hi All,

in my model i have a pivot table with an expression based on another expression (column()).

the rows are presented OK but the total is taking all the rows into the value. i.e. :

the total of expression b should be 28.

any ideas ?

advanced thanks

Kushal_Chawda — Sun, 13 Dec 2020 14:56:29 GMT

@ilanbaruch For that expression, change the Total Model as " Sum" Of rows.

ilanbaruch — Mon, 14 Dec 2020 06:49:08 GMT

this option is greyed out

MayilVahanan — Mon, 14 Dec 2020 07:13:22 GMT

Try like below

If(Rowno() = 0 or isnull(Rowno()), Sum(Aggr(urexpression, dim1)), urexpression)

Hope it helps