Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with expression in chart, and suppressed values

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

1 Solution

Accepted Solutions
jsaradhi
Specialist
Specialist

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.

1.png

View solution in original post

6 Replies
jsaradhi
Specialist
Specialist

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.

1.png

View solution in original post

Not applicable
Author

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

Chart_Dim.JPG.jpg

jsaradhi
Specialist
Specialist

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:

1.png

Not applicable
Author

Could you please send me qvw?

jsaradhi
Specialist
Specialist

here you go!

jsaradhi
Specialist
Specialist

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)