Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Not applicable
Author

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

View solution in original post

9 Replies
MK_QSL
MVP
MVP

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.

Not applicable
Author

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

MK_QSL
MVP
MVP

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

Not applicable
Author

great

MK_QSL
MVP
MVP

Please close this thread by selecting CORRECT or HELPFUL answer.

Thanks

Not applicable
Author

but its not displaying sufficient result

Not applicable
Author

hi manish

i am getting same result for both exists and non exists

MK_QSL
MVP
MVP

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

Anonymous
Not applicable
Author

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