Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
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.