topic Problem with count expression in QlikView

Problem with count expression

Wed, 25 May 2011 13:44:44 GMT

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

Re: Problem with count expression

Wed, 25 May 2011 13:51:17 GMT

Check this attached application.

- Sridhar

Problem with count expression

pat_agen — Wed, 25 May 2011 13:57:15 GMT

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.

Problem with count expression

Wed, 25 May 2011 14:00:34 GMT

Thank you for the fast answer ! It works great 😃