Discussion Board for collaboration on QlikView Layout & Visualizations.
See chart below:
I need to hide the "Maybe"s and Still have Yes/No populate with 45%.
I have also attached my sample QV document.
I imagine I can do this in the Expression tab? But Im not sure what syntax to use.
Thank you in advance for any input!
Hi try this in the dimesion field
this will show only yes, no and check mark Suppress when value is null
That solves the hiding of the bar, but makes the values 50% and 50%
use this in calculated dimension
= if (response <>'Maybe',response)
1. Change expression to =TextCount(Response) / TextCount(TOTAL Response)
2. Show only first 2 dimensions
Sometimes there are more "Maybes" than "Yes" or "No". So your solution to show only first two dimentions shows this in that scenario:
Also there are about 15+ values in the real dashboard Im trying to implement and they fluxuate.
=TextCount(if(Match(Response, 'Yes', 'No', 'List here oher options you wish to appear'), Response)) / TextCount(TOTAL Response)
and you can uncheck the Dimension Limitation
The other options I want to list are variable and come from the database on reload.
I did try this...
=TextCount(if(Response <>'Maybe',Response)) / TextCount(TOTAL Response)
But I still Get 50% and 50% not 45% and 45%
My QlikView version (latest) shows OK the attachment 45% and 45%
Looks good, But the difference is that I have two expressions. I need the percent and the count(left hand bar need to be a count).
i.e 45% and 9 for Yes/No
the count is displayed on the left side, in your example there is a percent on the left side.
When I try to create/modify the second expression the "Maybe" shows back up.