topic Re: Hide and show in QlikView

Hide and show

Nagaraju_KCS — Tue, 01 Mar 2016 04:02:12 GMT

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..

Re: Hide and show

tamilarasu — Tue, 01 Mar 2016 04:06:28 GMT

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.

Re: Hide and show

MayilVahanan — Tue, 01 Mar 2016 04:11:31 GMT

PFA