Hide and show

[Nagaraju_KCS]

Hi Community,

I am doing Gender Distribution,

Suppose If i have more than F percentage i want to show one Image..

If i have more than M percentage i want to show Different Image..

How to write hide and show conditions for 2 Images based on Gender Percentage..????

Thanks in Advance..

[tamilarasu · Accepted solution]

Hi,

You can use conditional hide in this case.

Male Expression

=Count({<genger={'M'}>}ID)/Count(TOTAL ID)*100>Count({<genger={'F'}>}ID)/Count(TOTAL ID)*100

Female Expression

=Count({<genger={'M'}>}ID)/Count(TOTAL ID)*100<Count({<genger={'F'}>}ID)/Count(TOTAL ID)*100

Edit: If the male and female percentage is equal, the above expression will not show any images. To avoid that replace less than and greater than symbols as <= and >= in above expressions. You can see both the images () whenever the percentage is equal.

[MayilVahanan]

HI

PFA