Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Announcements
Announcement: We have made updates to resolve a Page Not Found error. If you still get this error, please let us know in the Community Corner.
Highlighted
Not applicable

How to show male & Females Percentages on particular Pictures.

Hi,

I have data with different countries and with their ID, Gender.

what i want see is based on the selections i want to get "MALE %" & "FEMALE %" on perticular pictures. and also want to use list box so that when i click on particular country it has to show that country related Male & Female Count on figures.

PFA For sample data.

Can you please help me on this.

Thanks,

MaleNFemale.PNG

1 Solution

Accepted Solutions
MVP
MVP

Re: How to show male & Females Percentages on particular Pictures.

Use a text box to show the image.

Then overlay two text boxes with background transperancy and using expression to calculate your percentages.

3 Replies
MVP
MVP

Re: How to show male & Females Percentages on particular Pictures.

Use a text box to show the image.

Then overlay two text boxes with background transperancy and using expression to calculate your percentages.

Not applicable

Re: How to show male & Females Percentages on particular Pictures.

Hi Swuehl, Can you please give expression for that. Thank you for your response. Thanks, Kq

MVP
MVP

Re: How to show male & Females Percentages on particular Pictures.

For male percentage, use something like

=Num( Count({<Gender = {'M'}>} ID) / Count(ID), '00%')

resp. for female:

=Num( Count({<Gender = {'F'}>} ID) / Count(ID), '00%')


This should already consider selections in Country field (note that with your sample data in the Excel file, you won't see many counts per country).