topic Help with expression in chart, and suppressed values in QlikView

Help with expression in chart, and suppressed values

Wed, 20 Aug 2014 18:56:02 GMT

Hello all,

As you have read, I have a small problem that I cannot solve on my own.

I need to sum all red values, so that I can get the percentage marked in green.

The blue values should be suppressed, and the final chart should look like picture 2.

I have tried with Len(trim(Location)>0, Location) as a calculated dimension, as well as adding same conditional to the expression.

Also I have attached the sample qvw with scrambled data, which is the application that I'm having trouble with.

Thanks in advance

Anonymous — Wed, 20 Aug 2014 19:31:37 GMT

instead of a constant number assigned to the variable TotalSizeOfQvw, modify its definition to

=sum(total {<Location=E({<Location={''}>})>}Workfiles.Length)/1048576

and make sure to check suppress when value is null for Location dimension.

Wed, 20 Aug 2014 19:31:57 GMT

Select "Suppress When Value is Null" option on the Chart Properties --> Dimensions

Anonymous — Wed, 20 Aug 2014 19:48:59 GMT

in addition to the two things in my previous post, you need to check show partial sums in presentation tab. then you will have the following:

Wed, 20 Aug 2014 19:58:51 GMT

Could you please send me qvw?

Anonymous — Wed, 20 Aug 2014 20:39:24 GMT

here you go!

Anonymous — Wed, 20 Aug 2014 20:41:17 GMT

sorry try this one...

ps: the variable seems to be getting recalculated at document open. use the following expression for Total size in %

sum(Workfiles.Length) / sum(total {<Location=E({<Location={''}>})>}Workfiles.Length)