Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

dave-firmograph
New Contributor

How should we optimally structure "family tree" data?

We have "family tree" style data, for organizations that looks like this. 

Parent Company:  Chevron Corp

  Direct Subsdiaries:  Chevron USA, A, B, C, D

     Subsidiaries:  A1, A2, B1, B2, B3, B4, C1, C2, D

        etc

This data is currently in a flat file table.  Generally once you hit 5 levels deep we are done.  Other data, such as site locations and financial information, can be associated at any level. 

We have some flexibility, today, to structure the data in a way that will optimally work with Qlik. 

Has anyone encountered this use case before?  Are you aware of best practices in terms of the supporting database structure that optimally support connection to BI? 

I'm sure we can use drill-down dimensions, but the tricky thing is, we don't always have the same levels of depth as we do in the case of country - state - city.  Some organizations will have 1 level, others will have 5. 

2 Replies
rachel_delany
Contributor

Re: How should we optimally structure "family tree" data?

Perhaps a good option would be to have all of the companies within one table and have a 'Parent' column. This way you can set up the code to iterate and join the data as you need.

Re: How should we optimally structure "family tree" data?

Maybe this is helpful: Unbalanced, n-level hierarchies

- Marcus

Community Browser