Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with count expression

Hi everyone,

I'm new in QlikView and I have a table listing people and their gender (men or women). I want to make a pie chart which show the percentage of men and women.

Thanks for your answer.

Annie

1 Solution

Accepted Solutions
pat_agen
Specialist
Specialist

hi,

1. right click on page , select "new sheet object"->Chart from menu.

2. on general tab select "pie chart"

3. on dimesnions tab add "gender"

4. on expressions tab, add expressions as =count(fieldPeopleName)  - put in th ecount() whatevere the field containing your people is called.

5.make sure the "Relative" optin is ticked off.

that should do it.

View solution in original post

3 Replies
Not applicable
Author

Check this attached application.

- Sridhar

pat_agen
Specialist
Specialist

hi,

1. right click on page , select "new sheet object"->Chart from menu.

2. on general tab select "pie chart"

3. on dimesnions tab add "gender"

4. on expressions tab, add expressions as =count(fieldPeopleName)  - put in th ecount() whatevere the field containing your people is called.

5.make sure the "Relative" optin is ticked off.

that should do it.

Not applicable
Author

Thank you for the fast answer ! It works great 😃