Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
jsaradhi
Valued Contributor

Re: How to sum the shown values in chart

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

Not applicable

Re: How to sum the shown values in chart

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
Contributor II

Re: How to sum the shown values in chart

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

Re: How to sum the shown values in chart

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

Community Browser