Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have a loop in my datamodel. Can any one help me in resolving. Below is the Loop
Concatenate some of your tables - looks like you can concatenate Channel and Branch into both Data and Budget (assuming you need details from each) or you can just concatenate everything into one table. Have a look at https://community.qlik.com/t5/Qlik-Design-Blog/Fact-Table-with-Mixed-Granularity/ba-p/1468238 and the sample file linked in the comments of that post, as Henric covers it better than I could.
Thanks for the quick reply. if I concatenate Channel and Branch it again forms a loop with Budget and Data Tables.
I tried with concatenating all into single table, I'm getting performance issue due to huge data and cannot restrict the data further since I loaded only required data.
It seems like a common Circular Reference problem.
I think Or didn't mean that you should concatenate Channel and Branch, but to Join them into both tables Data and Budget. At the same time, you'll have to rename them so that they do not create additional Links.
Another solution (but a bit more complex) is to create a Link table between Data and Budget, and stuff your Channel & Branch Dimension values into that Link Table. That way you keep them in a single spot. This solution is better because you may want to aggregate Data / Budget per Channel or Branch...
Hi there.
I would Left Join Branch onto Channel and Budget but rename the fields.
If the Channel Code is not referring to a branch code, then rename it instead of joining.
Hope you come right.
Kingsley
Then try the second suggestion. You know, there were two of them...
There are a number of great resources available in the Community that discuss various aspects of Link Tables and their creation:
There are many more, but I think if you just read Henric's PDF start to finish, I guess you'll master Link Tables like an expert in no time.