Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master III
Master III

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
Partner - Master II
Partner - Master II

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.

Anonymous
Not applicable
Author

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

reddy-s
Master II
Master II

Yes you can.

Check this out:

Thanks,

Sangram

Ralf-Narfeldt
Employee
Employee

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
Author

thanks

oknotsen
Master III
Master III

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!