topic chart and expression help in QlikView

chart and expression help

Fri, 09 Oct 2015 08:51:06 GMT

Hi,

We have a chart that is showing responses to a question 'treated with respect'.

For the purposes of the chart we only want to show yes and no responses and exclude 'not answered'. So we have the following expression which works fine:

({<[PI4 Treated with Respect YN] = {'Yes'}>} [PI4 Treated with Respect YN]) + Count({< [PI4 Treated with Respect YN]= {'No'}>} [PI4 Treated with Respect YN])

However, we want to show these figures (300 = yes, 10 no) in percentage format on the chart. This is what we are struggling with...

We have tried this for example but doesn't work.

({<[PI4 Treated with Respect YN] = {'Yes'}>} [PI4 Treated with Respect YN]) + Count({< [PI4 Treated with Respect YN]= {'No'}>} [PI4 Treated with Respect YN])
/
Count(TOTAL{<[PI4 Treated with Respect YN] = {'Yes'}>} [PI4 Treated with Respect YN]) + Count(TOTAL{<[PI4 Treated with Respect YN] = {'No'}>} [PI4 Treated with Respect YN])

Any help would be greatly appreciated.

Chris

Re: chart and expression help

datanibbler — Fri, 09 Oct 2015 08:58:55 GMT

Hi,

the TOTAL operator only ignores chart_dimensions.

What you want to do is compare the YES-answers to the total of all answers and the NO answers in relation to the total of answers, no?

So the first part has to be only one of those parts, not both. And you can remove the TOTAL as it doesn't help you in this instance.

Apart from that, it does look fine as far as I can see.

HTH

Best regards,

DataNibbler

Re: chart and expression help

nagaiank — Fri, 09 Oct 2015 09:07:53 GMT

Use the following expressions:

Count({< [PI4 Treated with Respect YN]= {"Yes"}>} [PI4 Treated with Respect YN]) / Count({< [PI4 Treated with Respect YN]= {"Yes","No"}>} [PI4 Treated with Respect YN])

Count({< [PI4 Treated with Respect YN]= {"No"}>} [PI4 Treated with Respect YN]) / Count({< [PI4 Treated with Respect YN]= {"Yes","No"}>} [PI4 Treated with Respect YN])

Re: chart and expression help

Fri, 09 Oct 2015 09:25:42 GMT

Hi,

We want it to calcuate % of No's and Yes' compared to all Yes and No responses after its excluded the 'not answered':

40 Not answered

300 No

10 Yes

Total responses 310 for the purpose of this calculation

Chris