Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count of values in pie chart

Hi

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

10

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

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

8 Replies
sunny_talwar

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)


Capture.PNG

kkkumar82
Specialist III
Specialist III

I think even your second is also three

Sorry counting mistake

Not applicable
Author

Hi

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

sunny_talwar

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

sunny_talwar

See if this is better

Not applicable
Author

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

Not applicable
Author

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

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