topic how to make pie chart show proportion of selected values in total including unselected in QlikView

how to make pie chart show proportion of selected values in total including unselected

Mon, 05 Nov 2012 00:44:55 GMT

Hi.

Sorry for the lengthy subject (which may sound stupid to many). A newbie here and I think I am doing something wrong. My problem is that I couldn't make the pie chart show the correct proportion of the selected values in the total. I am attaching screenshots to better explain my problem. The first image which shows all the values is okay. However, if I select values from the 'WATER_DESC" field list, the pie chart shows total only of the selected values. What I want to achieve is to get the proportion of the selected values in the total number of respondents.

Thanks and cheers.

Re: how to make pie chart show proportion of selected values in total including unselected

Mon, 05 Nov 2012 02:32:01 GMT

Hi,

May I know your expression? How is it look like? Under expressions tab, did you check the relative box?

Regards,

Janzen

Re: how to make pie chart show proportion of selected values in total including unselected

Mon, 05 Nov 2012 06:14:18 GMT

Hi, Janzen.

Thanks for responding. Yes, I checked the relative box. But it seems that it is only computing against the total number of respondents of the selected values not of the entire number of respondents...