topic Re: How Can I remove certain Items from a List Box in QlikView

How Can I remove certain Items from a List Box

Thu, 19 Sep 2013 05:29:43 GMT

I don't want to show particular data in a list box.

I have tried this but not working for me.

in the expression pane

if(ListBoxfield='D',Null(),ListboxField)

what it does for me is:

A A

B B

C C

D -

what I want is :

Please Help.

Regards,

Gaurav Tyagi

tresB — Thu, 19 Sep 2013 05:32:23 GMT

Try:

if(ListBoxfield<>'D',ListboxField)

Thu, 19 Sep 2013 06:03:40 GMT

Still the same result, No change.

I'm writing it in the second tab i.e. Expression Pane is it the place where I have to write it?

tresB — Thu, 19 Sep 2013 06:09:14 GMT

No. See the screenshot:

Thu, 19 Sep 2013 06:10:42 GMT

TAKE ONE LIST BOX

AND GOTO LIST BOX PROPERTY AND IN THE EXPRESSION TYPE THE BELOW CODE(

=IF(OrderNo <>'D', OrderNo)

CHECK THE SCREEN SHOT (ATTACHED).

suniljain — Thu, 19 Sep 2013 06:21:31 GMT

You can use following expression

if(Len(ListBoxfield)>1,ListboxField)

Thu, 19 Sep 2013 06:33:23 GMT

I didn't scroldown that much before have too many fields in the table

Thanks