topic Re: how to add within pivot? in QlikView

how to add within pivot?

Wed, 08 May 2013 10:24:45 GMT

Hi everyone,

I´ve created a pivot table in QlikView and would like to calculate the difference between the subtotals (see attached excel).

Any ideas how to define the expression in QlikView?

Thanks,

David

sujeetsingh — Wed, 08 May 2013 11:29:55 GMT

Use expression Colmn1 - Column2

Wed, 08 May 2013 12:01:41 GMT

hi,

add Dimensionality() as an extra expression .

(Dimensionality() > 0,

sum

( total col1) - sum(total col2)) .

Dimensionality() indicates the level of subtotals in pivot tables. For example, if you have a pivot table with dimensions A, B, C and D,

the expressions will have a dimensionality of 5

subtotals for D will have a dimensionality of 4

subtotals for C will have a dimensionality of 3

subtotals for B will have a dimensionality of 2

subtotals for A will have a dimensionality of 1

the grand total will have a dimensionality of 0

This allows you to tailor the expression to the return the correct value for the totals if you need something other than simple subtotals.

Wed, 08 May 2013 13:38:03 GMT

I´ve tried but it doesn´t work 😞