Excluding fields in a list

[knightwriter]

Hi All,

I have list of a hundred or so people, how do I exlcude Joe Bloggs for example?

Do I use the <>=Joe Bloggs?

[alexandros17]

In a query you can write:

Select

...

From

...

Where People <> 'Joe Bloggs';

In a chart (Table) if People is a dimension then you can edit the dimension and write:

If(People <> 'Joe Bloggs', People, Null())

then check the box "Exclude Null Values"

let me know

[sunny_talwar]

Are you excluding while loading or within your chart?

In script:

LOAD allYourFields,

          People

FROM xyz

Where not Match(People, 'Joe Bloggs');

In Chart:

=Sum({<People -= {'Joe Bloggs'}>}) something)

[Kushal_Chawda]

From Source Table

Tab:

SQL SELECT *

FROM TABLE

WHERE upper(YourField) <>'JOE BLOGGS'

Store Tab into Path\Table.qvd;

From QlikView script

load *

FROM Table.qvd(qvd)

where lower(Yourfield)<>'joe bloggs';

From QlikView front end

In chart ,

Expression - Sum({<Yourfield -={'Joe bloggs'}>}Value)

[knightwriter]

Hi Sunny,

Now I believe there is no formula needed. I just want the full list in a List Box to exclude Joe Bloggs. I have tried your expression but see error below. Many thanks.

[sunny_talwar · Accepted solution]

Try this expression:

If(Medal.Person <> 'Joe Bloggs', Medal.Person)