topic Re: Create a percentage pie chart with preselected values in QlikView

Create a percentage pie chart with preselected values

peterderrington — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'm sure someone will be able to help me again with the syntax on this one......

I have a pie chart that shows the percentage of times something happens (Field = [Questions Complete] = 'Yes'), it counts the number of times people answer a question divided by the total number of people.

Here is the current expression: Count({<[Questions Complete]={"Yes"}>}[Questions Complete])/Count(TOTAL [Questions Complete])

This works perfectly however what i want to do is replicate this chart but only show a specific selection of those people.

(Specific people being from a certain 'Place' but not from a certain 'Place to' providing they answered the question as "Yes")

I attempted to alter the expression to a similar one i already have that can count the specific people but i'm clearly doing something wrong.

Count({<Place={'09'},[Place to]-={'07','FAS'}>}[Questions Complete]='Yes')/Count({<Place={'09',[Place to]-={'07','FAS'}>}[Questions Complete])

Can anyone help?

Re: Create a percentage pie chart with preselected values

sergio0592 — Tue, 30 Oct 2018 15:49:18 GMT

It miss a bracket:

Count({<Place={'09'},[Place to]-={'07','FAS'}>}[Questions Complete]='Yes')/Count({<Place={'09'},[Place to]-={'07','FAS'}>}[Questions Complete])

Re: Create a percentage pie chart with preselected values

peterderrington — Tue, 30 Oct 2018 15:54:18 GMT

Thanks for spotting that, unfortunately that was just my bad typing putting it on here.

When i use that expression it shows it as 100% which isn't correct.

Re: Create a percentage pie chart with preselected values

Jesh19 — Tue, 30 Oct 2018 16:00:00 GMT

Try this.

Count({<Place={'09'},[Place to]-={'07','FAS'},[Questions Complete]={'Yes'}>}[Questions Complete])

Count({<Place={'09'},[Place to]-={'07','FAS'}>}[Questions Complete])

Re: Create a percentage pie chart with preselected values

atoz1158 — Tue, 30 Oct 2018 16:05:26 GMT

Try

Count({<Place={'09'},[Place to]-={'07','FAS'}>}[Questions Complete]='Yes')/Count({<Place={'09'},[Place to]-={'07','FAS'}>} TOTAL [Questions Complete])

Adrian

Re: Create a percentage pie chart with preselected values

peterderrington — Tue, 30 Oct 2018 16:13:35 GMT

Fantastic, this worked a treat.

Thank you very much.