Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Champion III
Champion III

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
Champion III
Champion III

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.

sunny_talwar

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

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