Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
ak00428233
Contributor III
Contributor III

Condition clause while writing where not exist condition

Hi All,

I have gone through Exists and not exists condition.Could you please guide me regarding the condition.

Employees:

LOAD * inline [

Employee|ID|Salary

Bill|001|20000

John|002|30000

Steve|003|35000

] (delimiter is '|');

Citizens:

Load * inline [

Name|Address|ID

Bill|New York|001

Mary|London|004

Steve|Chicago|003

Lucy|Paris|005

John|Miami|002

] (delimiter is '|');

EmployeeAddresses:

Load Name as Employee, Address Resident Citizens where not Exists (Employee, Name);

In the above expression the condition was used between (Employee,Name).But could any suggest me to use this condition for ID also in the same table EmployeeAddresses.

Thanks in advance

Regards,

Anu

1 Solution

Accepted Solutions
YoussefBelloum
Champion
Champion

Hi,

try this:

.

.

.

EmployeeAddresses:

Load Name as Employee,

          Address,

          ID

Resident Citizens

where not Exists (Employee, Name) and not exists(ID);

View solution in original post

4 Replies
YoussefBelloum
Champion
Champion

Hi,

try this:

.

.

.

EmployeeAddresses:

Load Name as Employee,

          Address,

          ID

Resident Citizens

where not Exists (Employee, Name) and not exists(ID);

View solution in original post

ak00428233
Contributor III
Contributor III

Thank you youssef. It is working fine now.

YoussefBelloum
Champion
Champion

You're welcome.

Good luck

ak00428233
Contributor III
Contributor III

Thank you youssef.