topic exist function in QlikView

exist function

qlikview979 — Fri, 17 Apr 2015 12:30:20 GMT

What is exist function ,how to use exist function ?

petter — Fri, 17 Apr 2015 15:41:17 GMT

Exist() is used in a Load Script to check if some value already exists in a given field. It returns true if you have a match and false if you don't.

sunny_talwar — Fri, 17 Apr 2015 15:43:33 GMT

Please find a snippet from the help section of QlikView if you have not already seen this.

Best,

Sunny

sunny_talwar — Fri, 17 Apr 2015 15:48:20 GMT

Here is an example for you to look at:

Table1:

LOAD * INLINE [

Number

];

Table2:

LOAD * INLINE [

Number2

];

Table:

LOAD RowNo() as Key,

Number2

Resident Table2

Where Exists(Number, Number2);

DROP Tables Table1, Table2;

Output in Table Box object looks like this:

I hope this would be helpful.

Best,

Sunny