topic Where exists (Fieldname, 'Fieldvalues')? in QlikView

Where exists (Fieldname, 'Fieldvalues')?

nihhalmca — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Can we use where exists() on field value? if possible can you share examples.

For instance:

1. Where exists (Fieldname, 'Fieldvalue1');

2. Where exists (Fieldname, 'Fieldvalue1','Fieldvalue2');

Note: I found some thing in help like:

Exists(Employee, 'Bill') : Returns -1 (True) if the field value 'Bill' is found in the current content of the field Employee.

sunny_talwar — Tue, 11 Oct 2016 18:00:16 GMT

Why not use Match instead of Exists?

Where Match(Fieldname, 'Fieldvalue1','Fieldvalue2');

maxgro — Tue, 11 Oct 2016 18:49:36 GMT

I think Match is a better choice

if you want exists:

where exists (Fieldname, 'Fieldvalue1') or exists exists (Fieldname, 'Fieldvalue2') or .....

or you can load your values in a table

load * inline [

Values

Fieldvalue1,

Fieldvalue2

];

load

FieldName

from

...

where exists (Values, FieldName);

nihhalmca — Wed, 12 Oct 2016 11:54:00 GMT

Hi Maxgro - Thanks for your response.

Could you attach sample document because i tried earlier and could not find any difference on this:

where exists (Fieldname, 'Fieldvalue1') or exists exists (Fieldname, 'Fieldvalue2') or .....

marcus_sommer — Wed, 12 Oct 2016 13:17:56 GMT

Easier would be that you provide a small example with a few inline-data which others then could be modify.

- Marcus