Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Can I merge 5 excel files into 1 QlikSense App?

Hi There,

Can someone help me to create an App using the attached 5 excels?

All I want to see is the relationship amongst columns and tables. Viewing the data in table format should be enough without any pivot in a single view.

Any queries, pls let me know meanwhile.

Thanks in advance.

Cordially,

Mahesh

8 Replies
oknotsen
Honored Contributor III

Re: Can I merge 5 excel files into 1 QlikSense App?

Just drag-and-drop them into the Qlik Sense app and let the wizards help you?

What are the problems you are experiencing?

May you live in interesting times!
ogster1974
Honored Contributor II

Re: Can I merge 5 excel files into 1 QlikSense App?

Drag them into your app to create the upload scripts.  where you want a relationship between files ensure the key field names are named the same and Qlik will automatically join your data.  If you have fields in tables that are similar but should not be joined make sure they are named uniquely

For example

In your sales and Order tables you may have a Date make sure they are named Sales Date and Order Date to avoid incorrect/unexpected joining.

balrajahlawat
Esteemed Contributor

Re: Can I merge 5 excel files into 1 QlikSense App?

Just drag and drop all the excel into your QS app....then

Identify the link or common unique field b/w two tables and name it a common name...Run it...those two table would be linked...

Say, You are having two tables like, Source 5 - Sales History & Souce 2 - Order

May be here Order ID would be common in both the table,make it common name

reddys310
Honored Contributor II

Re: Can I merge 5 excel files into 1 QlikSense App?

Yes you can.

Check this out:

Thanks,

Sangram

reddys310
Honored Contributor II

Re: Can I merge 5 excel files into 1 QlikSense App?

rnt
Valued Contributor

Re: Can I merge 5 excel files into 1 QlikSense App?

As these five tables contain the same 5 fields, they will be concatenated into a single table when you add/load them into Qlik Sense.

Not applicable

Re: Can I merge 5 excel files into 1 QlikSense App?

thanks

oknotsen
Honored Contributor III

Re: Can I merge 5 excel files into 1 QlikSense App?

If your question is answered, please flag the Correct Answer and possibly Help Answers.

If not, please make clear what part of your question needs more help .

May you live in interesting times!