Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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)