Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Re: show yes/no reponses question in %

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
Valued Contributor II

Re: show yes/no reponses question in %

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

Re: show yes/no reponses question in %

Hi,

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

Not applicable

Re: show yes/no reponses question in %

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

satyadev_j
Valued Contributor

Re: show yes/no reponses question in %

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
Valued Contributor II

Re: Re: show yes/no reponses question in %

Find the attached,

Hope it helps, Otherwise Please ask..

Kind Regards

Khan...

ahhhhhh you alreay got the answer...

Not applicable

Re: show yes/no reponses question in %

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

thanks

satyadev_j
Valued Contributor

Re: show yes/no reponses question in %

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