Discussion Board for collaboration related to QlikView App Development.
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
not sure i understood your requirement completely, but try enabling show partial sums in Presentation tab.
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%
hola,
Espero me puedas entender,
agregar expresion
sum(size) / sum(total size) // sizeIn%
después realizar
te debe de quedar algo similar
saludos
But when I suppress the location, sum of % is not 100.