Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to load data with a filter on related table

Hello! I have the following problem. I want to load data from three excel tables:

fsdfds.png

BUT I don't want to load sales in Brazil. So, my result must be:

fsdfds.png

If I could use SQL, I would wright the following code:

SELECT * FROM Sales LEFT OUTER JOIN Managers ON Sales.[Manager ID]=Managers.[Manager ID] LEFT OUTER JOIN Regions ON Managers.[Region ID]=Regions.[Region ID] WHERE NOT Regiopns.Name LIKE 'Brazil';

What loading commands should I wright in QlikView loading script??? I have been looking for solution about 5 hours and I couldnt solve this problem. Help, please!

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

So use this script,

TEMP:

Load * FROM Sales;

LEFT JOIN

Load * From Managers;

LEFTJOIN

Load * From Regions ;

MyTable:

noconcatenate

Load * resident TEMP Where [Region ID] <> 2;

drop table TEMP;

let me know

View solution in original post

6 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Load * FROM Sales;

LEFT JOIN

Load * From Managers;

Inner JOIN

Load * From Regions Where [Region ID] <> 2;

let me know

Anonymous
Not applicable
Author

Something like this should work:

Sales:

LOAD

Amount,

Manager_ID

From Sales;

Left join(Sales)

Load

Name as ManagerName,

Manager_ID,

Region_ID

From Managers

where not Region_ID=2;

Left join(Sales)

LOAD

Names as RegionName,

Region_ID

From Regions;

Not applicable
Author

I lose manager with ID=3 if I use this script

alexandros17
Partner - Champion III
Partner - Champion III

So use this script,

TEMP:

Load * FROM Sales;

LEFT JOIN

Load * From Managers;

LEFTJOIN

Load * From Regions ;

MyTable:

noconcatenate

Load * resident TEMP Where [Region ID] <> 2;

drop table TEMP;

let me know

Not applicable
Author

Unfortunately, for this script I have the following strange result:

555.png

Not applicable
Author

IT WORKS! Thank you very much, Alessandro!