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.

singhcv123
New Contributor II

how to use Not Exist function

Hi ,

I have one query regarding not exists ...........

I have 2 tables and from there i want to filter some data and those IDs i want to use some where else in table..................

Query is .......

Table1:

LOAD [guest id]

resident booking,medium

where  booking_source ='Email';

Table 2:

LOAD [guest id]

resident all.booking

where not exists ([guest id]);

DROP TABLE Table1;

Actually i want to get only those guest ids ..those do not have valid email................

so as per my scenerio.....first iam getting guest ids  having email ....from booking,medium table and than quering in all .booking table.......

finally i want to use the data from table2 to reference other table...........

but not working please suggest

2 Replies
Chanty4u
Esteemed Contributor III

Re: how to use Not Exist function

what is  all.booking?

use as [all.booking]

Chanty4u
Esteemed Contributor III

Re: how to use Not Exist function

and chk dis too

EXISTS()