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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
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??]