Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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
Valued Contributor

Problem with count expression

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.

3 Replies
Not applicable

Re: Problem with count expression

Check this attached application.

- Sridhar

pat_agen
Valued Contributor

Problem with count expression

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

Problem with count expression

Thank you for the fast answer ! It works great =)