Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: pls look into this issue urgent?

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

9 Replies
MK_QSL
Not applicable

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.

Not applicable

Re: pls look into this issue urgent?

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

MK_QSL
Not applicable

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

Not applicable

Re: pls look into this issue urgent?

great

MK_QSL
Not applicable

Re: pls look into this issue urgent?

Please close this thread by selecting CORRECT or HELPFUL answer.

Thanks

Not applicable

Re: pls look into this issue urgent?

but its not displaying sufficient result

Not applicable

Re: pls look into this issue urgent?

hi manish

i am getting same result for both exists and non exists

MK_QSL
Not applicable

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

neetha_p
Not applicable

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