topic Re: Re: Re: show/hide the rows in QlikView

show/hide the Rows

Anonymous — Mon, 29 Sep 2014 10:19:48 GMT

Hi,

Here am using variables for Stretch and RPI. If stretch and RPI is "No", then it will show the value as 0. So i want to hide the rows when it is showing '0'. since in presentation tab i checked supress zero values.

Please someone help out to achieve the same.

Thnks,

Nisha loganathan

Re: show/hide the rows

ashfaq_haseeb — Mon, 29 Sep 2014 10:26:36 GMT

Hi,

Go to Chart properties --> Expression tab --> Select your Expression check conditional and write If(Stretch>0).

Regards

ASHFAQ

Re: Re: show/hide the rows

Anonymous — Mon, 29 Sep 2014 10:58:50 GMT

Hi,

Thanks for your reply. But when am doing as per what yo said, that record is not showing but at the same time i want PIP row fully. When am doing like this , PIP value 10 is not showing.

i attached the application for your reference.

Re: Re: Re: show/hide the rows

ashfaq_haseeb — Mon, 29 Sep 2014 12:48:18 GMT

Hi,

Check this.

Regards

ASHFAQ

Re: show/hide the rows

Anonymous — Mon, 29 Sep 2014 14:16:32 GMT

Hi,

Thank yo so much. It helped me a lot