topic Re: Excluding fields in a list in QlikView

Excluding fields in a list

knightwriter — Fri, 24 Jul 2015 14:18:50 GMT

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?

Re: Excluding fields in a list

alexandros17 — Fri, 24 Jul 2015 14:21:14 GMT

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

Re: Excluding fields in a list

sunny_talwar — Fri, 24 Jul 2015 14:28:15 GMT

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)

Re: Excluding fields in a list

Kushal_Chawda — Fri, 24 Jul 2015 14:30:55 GMT

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)

Re: Excluding fields in a list

knightwriter — Fri, 24 Jul 2015 14:49:11 GMT

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.

Re: Excluding fields in a list

sunny_talwar — Fri, 24 Jul 2015 14:51:38 GMT

Try this expression:

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