topic Re: Count of values in pie chart in QlikView

Count of values in pie chart

Wed, 20 Apr 2016 09:38:19 GMT

I have my data as below

Table

emp_id status Item

1 TRUE 1

2 FALSE 0

3 TRUE 1

4 TRUE 0

5 FALSE 1

6 Don’t know 1

7 Don’t know 0

I want the count in a single pie chart in which

i want the count of emp_id whose item =1 and status = True or False (from above table count is 3)

i want the count of emp_id whose item =1 and status = True or False or Don't know (from above table count is 4)

Thanks

sunny_talwar — Wed, 20 Apr 2016 09:41:22 GMT

Create a pie chart with no dimension and these two expressions

1) Count({<Item = {1}, status = {'TRUE', 'FALSE'}>}emp_id)

2) Count({<Item = {1}, status = {'TRUE', 'FALSE', 'Don''t know'}>}emp_id)

kkkumar82 — Wed, 20 Apr 2016 09:51:01 GMT

I think even your second is also three

Sorry counting mistake

Wed, 20 Apr 2016 12:11:55 GMT

Thank you so much but i cant drill down into the pie chart

sunny_talwar — Wed, 20 Apr 2016 12:15:06 GMT

You want to be able to select one or the other section of the pie? Is that the goal?

sunny_talwar — Wed, 20 Apr 2016 12:31:06 GMT

See if this is better

Thu, 21 Apr 2016 03:22:00 GMT

Hi sunny yes when clicks on the second legend it should be drilled into a single pie

Thu, 21 Apr 2016 03:23:09 GMT

if i ada a single dimension and a single expression then i am able to drill into pie chart

but with out dimension i cant be able to drill

sunny_talwar — Thu, 21 Apr 2016 08:07:35 GMT

I did attach another qvw with the ability for the user to select one part of the pie, did you check it out?