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.
Just drag-and-drop them into the Qlik Sense app and let the wizards help you?
What are the problems you are experiencing?
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
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.
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
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 .