Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How Can I remove certain Items from a List Box

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 :

A

B

C

Please Help.

Regards,

Gaurav Tyagi

1 Solution

Accepted Solutions
tresesco
MVP
MVP

No. See the screenshot:

asd.png

View solution in original post

6 Replies
tresesco
MVP
MVP

Try:

if(ListBoxfield<>'D',ListboxField)

Not applicable
Author

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?

tresesco
MVP
MVP

No. See the screenshot:

asd.png

Not applicable
Author

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

PP.PNG.png

suniljain
Master
Master

You can use following expression

if(Len(ListBoxfield)>1,ListboxField)

Not applicable
Author

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

Thanks