Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

use of exists in QV

Hi guys ,

I am new to qlikview .

Can you please give me a simple example of exits() with same and different column name?

It will be helpful if you will take a table on Employee and department.

Thanks,

Amit

3 Replies

Re: use of exists in QV

Ti,

Try Like this

Table1:

Load * inline

[

A

1

2

3];

Table2:

Load * inline

[

B

1

2

3

4

5] where Exists(A,B) ;

Now if you check o/p of table b.

It will be

1

2

3.

Hope it helps

Regards

ASHFAQ

Re: use of exists in QV

Hi,

There are many examples

TABLE1:

LOAD * INLINE [

    F1, F2

    1, a

    2, b

    3, c

];

LOAD * INLINE [

    F1, F2

    4, d

    4, e

]

WHERE Exists(F1);

If you load this two you get only 1,2,3

Regards

Anand

Re: use of exists in QV

Hi,

And another one also

LOAD * Inline

[

ITEM,class,dd

1

2

3

4

12

14

88

89

90

];

//Join

NoConcatenate

LOAD * Inline

[

ITEMID,class,dd

1

2

3

4

5

6

7

8

9

0

10

11

12

13

14

] Where Exists(ITEM,ITEMID);

Regards

Anand

Community Browser