Qlik data model

[Iswarya_]

Hi All,

I have two excel files i.e., Excel1 and Excel2. Each of these excels has 2 tabs i.e., Tab1 and Tab2.

The Tab1 and Tab2 are associated based on key field S_Key for Excel1 and same way Tab1 and Tab2 are associated based on key field T_Key for Excel2.

The field names are common between these two excel files. I want to build a Ad hoc report. Please let me know how can the data model be built?

For now, I have used Qualify all fields except Key Field and associated them.

Need suggestions.

[sidhiq91]

@Iswarya_ There are different ways to resolve the issue like concatenated load, link tables etc. It would be better if you can share the sample data and I can help you out.

[Iswarya_]

Hi @sidhiq91 ,

Thank you for the reply. 

Attaching sample data for reference.

I want to create 2 sheets in Qlik. "Dashboard1" will have only the details present from Tab1 and Tab2 of Excel1 as Ad hoc. Similarly for "Dashboard2" will have only the columns present from Tab1 and Tab2 of Excel2 as Ad hoc.

There are few columns in common between Tab1 and Tab2.

[oskartoivonen]

Try concatenating the tab1-tables together, and concatenating the tab2-tables together. Combine S_Key and T_Key into a single key field. Whichever fields they do not share will be null for the other data. Hardcode a datatype field in tab1 with value "S" for excel1 and value "T" for excel2. You can then create measures on different sheets using the datatype as part of the measure set analysis to only retrieve the rows you're interested in displaying.