Use subtotal in expression in pivot table

[Anonymous]

Hi,

I have this pivot table:

What I want to do in the second column is: value of Jerarquia 2 / Total value of Jerarquia 1

For example:

Jerarquia 1 subtotal = 30 then the second expression should be = 10 / 30 ==> 0,33..

...

Jerarquia 2 subtotal= 20 then the second expression should be = 10 / 20 ==> 0,5

Who can I set the expression to take the subtotal of the first dimension and use it. Can I do that with a qlikview's funtion?

Thanks,

Regards

[vishsaggi]

Hello Leandro,

Can you post a sample app to work on?

Thanks,
V.

[Anonymous]

Here is the app

[sunny_talwar · Accepted solution]

Try this:

Sum(Valor)/Sum(TOTAL <Jerarquia1> Valor)

[Anonymous]

Nice!

It's works!, thaks.

Can you tell me what you do when in the exp you put <Jerarquia1>? I tryed setting in the expression' set analisys {<Jerarquia1=>} but that doesn't work.

[sunny_talwar]

TOTAL <Jerarquia1> is telling the expression to Total as per Jerarquia1 dimension. To see what it is doing, create a new expression in your table using the expression -> Sum(TOTAL <Jerarquia1> Valor)

Note: TOTAL <FieldName> is different from {<FieldName>}. Second one (set analysis) will ignore selection in FieldName, while the first one will show the total by the listed dimension

[Anonymous]

Thanks! It's usefull