Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=
if(match(Response,'No' ,'Yes'),Response)
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)
See attachment.
1. Change expression to =TextCount(Response) / TextCount(TOTAL Response)
2. Show only first 2 dimensions
So close!!!
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.
OK, then:
=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.