topic Re: Need to Ignore one Value in List Box in QlikView

Need to Ignore one Value in List Box

Wed, 25 Nov 2020 16:16:04 GMT

Hi Friends,

I am Having a List box. I want to Ignore one particular Value. But it have to show empty cell.

Here In the above List box. It showing Target has 99% & 98%. It should not show 98%. but I need a empty cell

Can any one please help me on this Issue

Thank you,

Swarupaaa

tamilarasu — Thu, 16 Jun 2016 05:17:27 GMT

Hi Swarupa,

You can use listbox expression in this case.

=If(Target <>'98%', Target, '')

Anonymous — Thu, 16 Jun 2016 05:22:25 GMT

Just correcting it:

=If(Target <>'98%', Target, '')

Thu, 16 Jun 2016 05:23:26 GMT

Hi Nagraj,

This is the output

Thu, 16 Jun 2016 05:25:35 GMT

Hi BalRaj,

This is the Output if i use =If(Target <>'98%', Target, '')

tamilarasu — Thu, 16 Jun 2016 05:26:21 GMT

Thanks Balraj. Hope you are doing good.!!!

Anonymous — Thu, 16 Jun 2016 05:28:42 GMT

Yepp...Hope you too

Anonymous — Thu, 16 Jun 2016 08:12:24 GMT

Check the attachment, its working in my case..

Could you share your sample qvw?