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

Load only "some" customers

Dears,

How are you?

I've an important question for you guys.

I have two excel spreadsheets.

The Spreadsheet #1 have two collumns: The collumn 1 have the Serial Number and in the collumn 2 there is the Shop Name

The Spreadsheet #2 have two collumns: The collumn 1 have the Shop Name and in the collumn 2 there is the Latitude and Longitude


The problem is that some Shop Name's in the Spreadsheet #1 is not available at the Spreadsheet #2 and will never be, because it's not important for me.

So I would like to show in a chart only the Serial Number and Latitude/Longitude of the Shop Names available at the Spreadsheet #2. Not all the Shop Names.


Follow is on picture about what is happening.

So, to resume, what I need is:

How to show in a chart only the Serial Numbers of the Shop Name's available at the Spreadsheet #2? And not all the Serial Numbers!!!

Bye

4 Replies
Anonymous
Not applicable
Author

Hi Kelly

I am doing good thanks 🙂

For your Q, I am sure there are many ways to do this.

Here is one:

Add a line to your loading scripts that identifies from which Excelsheet the information comes so something like:

Load:

'Sheet2' As SheetID

From ....

This you can use in a calculated dimension like:

If (SheetID ='Sheet2' , Serial Numbers)

I hope this is helpfull

frank_carlsson
Partner - Contributor II
Partner - Contributor II

Hi,

Maybe you could use "where exists(ShopnameSpredsheet2,ShopnameSpredsheet1)" when loading spreadsheet #1.

You will have to load spreadsheet #2 before using exists()

Not applicable
Author

Sorry Frank, I didn't understand.

Can you give me an example?

Thanks for your attention and patience

frank_carlsson
Partner - Contributor II
Partner - Contributor II

No problems 😃

Table:
Load
ShopName,
Lat,
Long
From Spread2;


left join (Table) load
ShopName,
Serial
From Spread1
Where exists(ShopName,ShopName);