Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exclude values from excel spreadsheet when loading sql data

Hello

I am bit of a novice on Qlikview and can't seem to find a way of effectively excluding some data.

So the scenario is I have some data in an excel spreadsheet and I have master data in a sql table, I need to exclude the values that are in the spreadsheet when loading the sql data.

I have so far

Leads:

Select

BusinessName

FROM CampaignManagement..[Leads] L

where enddate is null;

Load

BusinessName,

address,

post_code,

phone,

email,

url

FROM

(biff, embedded labels, table is Adverisers$);

Where the business name in the excel file matches a business name in the Leads table, I need that row excluded.

Any help would be appreciated

18 Replies
Anonymous
Not applicable
Author

You are right, sorry...

Can you share a sample file, please?

Marc.

Not applicable
Author

Thats ok

I have attached a sample xls

the database table is just a simple table that holds businessname, address etc

Anonymous
Not applicable
Author

Please Find Attached.

Marc.

Not applicable
Author

Ok...I see

But if I add the BusinessName Column to the Tablebox, it adds in Ark Dental Practise...I need this to not show up at all

Anonymous
Not applicable
Author

In case you do not need excluded vales, then drop Leads table in script:

Drop table Leads;

Marc.

Not applicable
Author

Errmm... No i need Leads table

I need all the values in Leads except the ones that are in the excel...does that make sense?

Anonymous
Not applicable
Author

Well, depending on the requirements it will make sense or not. Check attached again and compare table object and table chart object.

I hope it clarifies your doubts.

Marc.

Not applicable
Author

Ok the chart object makes sense...but when i do it with my full data it tells Allocated Memory exceeded.

Not going well for me

Anonymous
Not applicable
Author

Vaishali,

I understand your initial requirement was accomplished. Please close this thread and open a new one to solve your Memory error.

Marc.