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

Circular Reference - any elegant solutions out there?

I've run into a circular reference issue and would really appreciate some ideas for a clean, intuitive solution. Attached is my data model.

Each person belongs to a single Cost Center and Country. Each Cost Center belongs to a node in the Cost Center hierarchy. Each Country has a High/Medium/Low Cost Location classification.

I'd like to set up a rate table at the Cost Center Hierarchy and H/M/L location intersection. Each person would then inherit the rate of the Cost Center Hierarchy and H/M/L location they belong to.

A simplified data model is attached - any thoughts on how to break this circular reference, and still get the required business logic above?

1 Solution

Accepted Solutions
srchilukoori
Specialist
Specialist

Create a compound key using the Country & Cost Center.circ.reference.png

View solution in original post

2 Replies
srchilukoori
Specialist
Specialist

Create a compound key using the Country & Cost Center.circ.reference.png

Not applicable
Author

Thanks - this makes sense. Will give it a shot. Appreciate the quick feedback.