Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

How to use a subtotal in a new expression

Hi everyone,

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

Screenshot_2.png

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

1 Solution

Accepted Solutions
vishsaggi
Esteemed Contributor III

Re: How to use a subtotal in a new expression

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,

V.

View solution in original post

2 Replies
vishsaggi
Esteemed Contributor III

Re: How to use a subtotal in a new expression

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,

V.

View solution in original post

Re: How to use a subtotal in a new expression

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

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