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

Do not show a value on a list box

Dears,

I have a list with lots of names, and I don't want to show only the name "000" how can I do it?


Then names are infinity, but only the name "000" can not be showed, neither included on the frequency formula.

How can I do it/

thanks

2 Replies
Not applicable
Author

Why don't you try with an  if ( fieldname <> ' 000 ' , fieldname)

erichshiino
Partner - Master
Partner - Master

On the list box, go to end of the field list. There choose <expression>

then you can write the expression

=if(name<>'000', name)

Or you could remove it on script

load if(name<>'000',name) as name ...

[did the concatenate work for you??]