# 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

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

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

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

Valued Contributor II

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

Find the attached,

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

Valued Contributor

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

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