topic Re: How to use a subtotal in a new expression in QlikView

How to use a subtotal in a new expression

Sat, 10 Sep 2016 19:05:00 GMT

Hi everyone,

y want to use the subtotal in a new expression like this...

TMCausa= sum({<PLANTA={'Malabrigo'} >}CANTABS)

vishsaggi — Sun, 11 Sep 2016 03:11:33 GMT

Did you try this:

= sum({<PLANTA={'Malabrigo'} >}CANTABS)/sum(Total {<PLANTA={'Malabrigo'} >}CANTABS)

IF not can you share a sample app that depicts the data above?

Thanks,

sunny_talwar — Sun, 11 Sep 2016 05:14:42 GMT

Or this if the total needs to change based on different ORIGEN:

=Sum({<PLANTA={'Malabrigo'}>}CANTABS)/Sum(TOTAL <ORIGEN> {<PLANTA={'Malabrigo'}>}CANTABS)