Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Check this attached application.
- Sridhar
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.
Thank you for the fast answer ! It works great 😃