Qlik Community

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Omkar13
Contributor III
Contributor III

How to join multiple tables while maintaining parent and child relationship

Hello Qlik Experts,

I m trying to combine multiple table while maintaining relationship between them. How should i achieve this? PFA data model for reference

Omkar13_0-1623212242818.png

 

Labels (2)
1 Solution

Accepted Solutions
Sammy_AK
Creator II
Creator II

having multiple calendars you cannot control the data on dates. as you will have multiple date columns, instead all the tables should be pointed to one calendar where you can control the date field better.

Master calendar as dimension helps you split date into multiple columns like Date, Month, Year, Week, QTR etc. if you link Date of master calendar to the other tables you can base-line the data on single date column. 

View solution in original post

6 Replies
Sammy_AK
Creator II
Creator II

can you provide more details? in your screen shot, i see tables are already associated. what do you mean by combine multiple tables ? are you referring to joining 2 or more tables here ?

  

Omkar13
Contributor III
Contributor III
Author

Thanks @Sammy_AK  for the reply.
I want to create a master table from above 4 table, e.g an All Issues table while still maintaining the atomicity. How can I achieve that? What do you think of this approach?
With one table, I can write better set analysis expression and create better charts, which is not the case now. 😞

Sammy_AK
Creator II
Creator II

You would either need to join the data using join / keep in the load script so that you have one big table or Concatenate data sets into one table by providing similar alias name and flag column to differentiate the data. 

the above association is also good enough to use set analysis and create charts as good as any other. you can use a variables and make set analysis more dynamic. if there is any specific scenario where you are unable find a solution ?

Omkar13
Contributor III
Contributor III
Author

Thanks @Sammy_AK 

I want to have a date range option on my dashboard. Each table have 5 date fields. So I created a bridge for each table and calendar.

[Table Theme]> [Bridge]> [CalendarTheme]

[Table Feature]> [Bridge]> [CalendarFeature]

[Table Epic]> [Bridge]> [CalendarEpic]

[Table Story]> [Bridge]> [CalendarStory]

I was hoping if I have one table, than  creating master calendar will be much easier and use. The problem now is how to create a bridge between four master calendar and create a Grandmaster Calendar.

Also I'm not sure if the above model is scalable as I plan to get different data set (At least 4) to the existing one. Hence I was finding a way to combine 4 table while maintaining the relationship as all the fields are same and use Issue Type to differentiate the data, in a similar way of how Canonical Date works.

What do you think? 

Sammy_AK
Creator II
Creator II

having multiple calendars you cannot control the data on dates. as you will have multiple date columns, instead all the tables should be pointed to one calendar where you can control the date field better.

Master calendar as dimension helps you split date into multiple columns like Date, Month, Year, Week, QTR etc. if you link Date of master calendar to the other tables you can base-line the data on single date column. 

View solution in original post

Omkar13
Contributor III
Contributor III
Author

Hi @Sammy_AK 

I was able to follow your advice and update my model.

Omkar13_0-1625637158629.png

Thanks for your help.