Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

show yes/no reponses question in %

Hi,

Can anyone advise how to do the following?:

We have a question that asks whether someone was treated with respect. The answer options are yes or no.

Want to show this in a chart by 'service area'. This is normally easy but doesnt like it with this chart. Here is expression whiohc makes sense but says no data to display:

([Q11 Did City West treat you with respect on this occasion?]= 'Yes')/Count(TOTAL [Q11 Did City West treat you with respect on this occasion?])='Yes'/'No'

Chris

1 Solution

Accepted Solutions
Not applicable
Author

I think you need this one:

Count({<[Q11 Did City West treat you with respect on this occasion?] = {'Yes'}>} [Q11 Did City West treat you with respect on this occasion?])

/ Count(  [Q11 Did City West treat you with respect on this occasion?])

cheers

View solution in original post

7 Replies
israrkhan
Specialist II
Specialist II

Try Like below:


For Yes.

=Count({<[Q11 Did City West treat you with respect on this occasion?] = {'Yes'}>} Yes/No) / Count( TOTAL {<[Q11 Did City West treat you with respect on this occasion?] = {'Yes'}>} Yes/No)


For No....

=Count({<[Q11 Did City West treat you with respect on this occasion?] = {'No'}>} Yes/No) / Count( TOTAL {<[Q11 Did City West treat you with respect on this occasion?] = {'No'}>} Yes/No)


and add 'service area' your  Dimension.



OR Share your sample Document...

Not applicable
Author

Hi,

Doesn't like yes/no. I have attached some sample app

Not applicable
Author

I think you need this one:

Count({<[Q11 Did City West treat you with respect on this occasion?] = {'Yes'}>} [Q11 Did City West treat you with respect on this occasion?])

/ Count(  [Q11 Did City West treat you with respect on this occasion?])

cheers

Anonymous
Not applicable
Author

Hi,

Something like below,

Count({<[Q11 Did City West treat you with respect on this occasion?] = {'Yes'}>} DISTINCT [Q11 Did City West treat you with respect on this occasion?])/

Count(DISTINCT [Q11 Did City West treat you with respect on this occasion?])

cnt.PNG.png

israrkhan
Specialist II
Specialist II

Find the attached,

Hope it helps, Otherwise Please ask..

Kind Regards

Khan...

ahhhhhh you alreay got the answer...

Not applicable
Author

Distinct is not correct in this case because you only have "Yes" "No" as possible values (2 distinct values)

thanks

Anonymous
Not applicable
Author

Yes, you are right.   My view was only based on data Chris has provided.