Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to exclude values

Hi,

I have a  very easy question...

When I create a listbox in properties I can show 'excluded values', that's ok..

But where do I can define this excluded values. I don't find a place to exclude a list of values..

Thanks in advance

Juan

2 Replies
Not applicable
Author

Create an 'expression' in your list (last option in 'Field') and use this:

=MAXSTRING({1-$<[Field Name]={'*'}>} [Field Name])

anbu1984
Master III
Master III

If you don't want to show list of values, then use expr like this

=If(Not(Match(Field,'ExclVal1','ExclVal2')),Field)