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 sum the shown values in chart

Hello all,

as you can seen there is a small request for help.

How do I sum all the values shown in chart, without suppressed values?

best regards

4 Replies
Anonymous
Not applicable
Author

not sure i understood your requirement completely, but try enabling show partial sums in Presentation tab.

Not applicable
Author

I want to sum all values from first expression, so that I can get something like this

                         Size   SizeIn%

Loc1                    1     10%

Loc2                    4   

Loc3                    5   

SuppressedLoc    69

so i want to sum the values, excluding suppressed values, to get 10% 40% 50%

jer_2011
Creator II
Creator II

hola,

Espero me puedas entender,

agregar expresion

sum(size) / sum(total size)   // sizeIn%

después realizarejemplo_19082014.png

te debe de quedar algo similar

ejemplo2_19082014.png

saludos

Not applicable
Author

But when I suppress the  location, sum of % is not 100.