Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
Not applicable

pls look into this issue urgent?

tab1:

LOAD * INLINE [

    F1, F2

    A, 1

    B, 2

    C, 3

    D, 4

];

tab2:

LOAD * INLINE [

    F3, F4

    A, AA

    B, BB

    C, CC

    E, EE

];

qualify *;---- what is the use of qualify here 

Table3:

LOAD

    *

RESIDENT tab2

WHERE not  Exists(F1, F3); not exists means what here. full confused .pls clarify it

drop table tab1;

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: pls look into this issue urgent?

what not exist(f1,f3) give according to scenario

View solution in original post

9 Replies
Highlighted
MVP
MVP

Re: pls look into this issue urgent?

Qualify will create the Table field like

Table3.F3

Table3.F4

When more than one fields are common in any table, QlikView will create a synthetic key.

Qualify is used to avoid the synthetic key.

Highlighted
Not applicable

Re: pls look into this issue urgent?

what not exist(f1,f3) give according to scenario

View solution in original post

Highlighted
MVP
MVP

Re: pls look into this issue urgent?

Where Exists (F1, F3)

It will load only those values of F3 which are present in F1.

Where Not Exists (F1, F3)

It will load only those values of F3 which are not present in F1

Highlighted
Not applicable

Re: pls look into this issue urgent?

great

Highlighted
MVP
MVP

Re: pls look into this issue urgent?

Please close this thread by selecting CORRECT or HELPFUL answer.

Thanks

Highlighted
Not applicable

Re: pls look into this issue urgent?

but its not displaying sufficient result

Highlighted
Not applicable

Re: pls look into this issue urgent?

hi manish

i am getting same result for both exists and non exists

Highlighted
MVP
MVP

Re: pls look into this issue urgent?

Please check enclosed files.

(1) is for Not Exists

(2) is for Exists

If you think that this solves your problems, select my answer as CORRECT ANSWER...

Thanks

Highlighted
neetha_p
Honored Contributor

Re: pls look into this issue urgent?

The Qualify statement is used for switching on the qualification of field names, i.e. field names will get the table name as a prefix.

see this post :Qualify using given keyword instead of table/source name