topic show yes/no reponses question in % in QlikView

show yes/no reponses question in %

Mon, 21 Jul 2014 07:24:12 GMT

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

Re: show yes/no reponses question in %

israrkhan — Mon, 21 Jul 2014 07:36:17 GMT

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...

Re: show yes/no reponses question in %

Mon, 21 Jul 2014 07:48:14 GMT

Hi,

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

Re: show yes/no reponses question in %

Mon, 21 Jul 2014 07:55:10 GMT

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

Re: show yes/no reponses question in %

Anonymous — Mon, 21 Jul 2014 08:04:52 GMT

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?])

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

israrkhan — Mon, 21 Jul 2014 08:07:23 GMT

Find the attached,

Hope it helps, Otherwise Please ask..

Kind Regards

Khan...

ahhhhhh you alreay got the answer...

Re: show yes/no reponses question in %

Mon, 21 Jul 2014 08:10:37 GMT

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

thanks

Re: show yes/no reponses question in %

Anonymous — Mon, 21 Jul 2014 08:20:57 GMT

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