I think I figured out how to correct for loops.
What is the best way to connect 2 tables with a lot of overlapping information but very different level of detail?
I have Table A that lists every little detail of transaction on SKU level and it's revenue
Table B: with a detailed budget that only covers about 80% of product SKUs that are in Table A
Table C: with high level full budget but it only goes down to Product brands and not individual SKUs
I tried breaking up the tables into different groups but i can't avoid creating 5-6 synthetic keys and my qlikview app closing on me as a result...
Please let me know if you have any advice.