Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
nkaragiorgos
New Contributor II

Multiple selections from excel

Hi,

I have load data from excel that has Customer_Code,Customer_Name,Sales and make the following table:

Customer_CodeCustomer_NameSales

100

A100

200

B50
300C200

My question is,

if i load data from another excel that has only the customer code and customer name (e.g. Customer_Code 200-300,Customer_Name B-C)

is it possible to make multiple selection from when i press a button only for the Customers of the second excel?

thanks

1 Solution

Accepted Solutions
Not applicable

Re: Multiple selections from excel

Dear Nikos,

As I tell you, you can add a column called 'source' to indicate where your data are coming from.

Sales:

LOAD

    Customer_Code,

    Customer_Name as SalesCustomerName,

    Sales,

  'File1' as Source

FROM [lib://sales/sales.xlsx]

(ooxml, embedded labels, table is Sheet1);

Customer:

LOAD

    Customer_Code,

    Customer_Name as CusCustomerName,

    'File2' as Source

FROM [lib://sales/Customers.xlsx]

(ooxml, embedded labels, table is Sheet1);

Then you will be able to filter your data on these 2 values.

Select File2 on a list containing sources in order to display only File2 content.

Source

File1

File2 (select this value)

Customer_CodeNameSales
1A100,00
3C200,00
6F456,00
9I446,00

Rgds,

Philippe

6 Replies
Silambarasan1306
Contributor III

Re: Multiple selections from excel

Hi,

Can you explain your question. Its not able to understand.

or

Share the screenshot how do u want to show your output.

lakshmikandh
Valued Contributor II

Re: Multiple selections from excel

Yes, load both sheets with same column name for common columns

Not applicable

Re: Multiple selections from excel

Hi Nikos,

If your question is how to load the both excel files in a single table, Lakshmikandh give you the solution: load both files with the same names of columns. It will concatenate automatically the data and you will have 3 columns containing the data of your 2 sources.

If your question is how to filter these data by source (File1, File2), after their load, you can simply add a column called Source. You will fill it with 'File1' during your first excel file loading & 'File2' during the second one.

You will obtain:

Customer_CodeCustomer_NameSalesSource

100

A100File1

200

B50File1
300C200File2

Rdgs

Philippe

nkaragiorgos
New Contributor II

Re: Multiple selections from excel

Sorry,

I will try to explain with more details

I have two excel files

Fist named

Sales   

Customer_CodeCustomer_NameSales
1A100
2B500
3C200
4D450
5E125
6F456
7G865
8H234
9I446
10J134

Second Customers

  

Customer_CodeCustomer_Name
1A
3C
6F
9

I

Load Data

Sales:

LOAD

    Customer_Code,

    Customer_Name as SalesCustomerName,

    Sales

FROM [lib://sales/sales.xlsx]

(ooxml, embedded labels, table is Sheet1);

Customer:

LOAD

    Customer_Code,

    Customer_Name as CusCustomerName

FROM [lib://sales/Customers.xlsx]

(ooxml, embedded labels, table is Sheet1);

Create a Table

  

Customer_CodeNameSales
1A100
2B500
3C200
4D450
5E125
6F456
7G865
8H234
9I446
10J134

Now

I want with a button to make multiple selection with values from the second excel

  

Customer_CodeNameSales
1A100,00
3C200,00
6F456,00
9I446,00

thanks

Not applicable

Re: Multiple selections from excel

Dear Nikos,

As I tell you, you can add a column called 'source' to indicate where your data are coming from.

Sales:

LOAD

    Customer_Code,

    Customer_Name as SalesCustomerName,

    Sales,

  'File1' as Source

FROM [lib://sales/sales.xlsx]

(ooxml, embedded labels, table is Sheet1);

Customer:

LOAD

    Customer_Code,

    Customer_Name as CusCustomerName,

    'File2' as Source

FROM [lib://sales/Customers.xlsx]

(ooxml, embedded labels, table is Sheet1);

Then you will be able to filter your data on these 2 values.

Select File2 on a list containing sources in order to display only File2 content.

Source

File1

File2 (select this value)

Customer_CodeNameSales
1A100,00
3C200,00
6F456,00
9I446,00

Rgds,

Philippe

nkaragiorgos
New Contributor II

Re: Multiple selections from excel

Thanks all for your answers