topic Re: How to exclude values in QlikView

How to exclude values

Anonymous — Mon, 27 Apr 2015 11:54:24 GMT

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

Mon, 27 Apr 2015 12:25:30 GMT

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

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

anbu1984 — Mon, 27 Apr 2015 12:30:00 GMT

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

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