Circular Reference in Y-Y design

[dhogan]

I have a data model which starts with a selection (far right).  Based on that selection the user needs to make two more selections (middle).  Upon completion of those now three selections the user is presented with results (far left).  This is effectively a Y branch out which then Ys back to a final result.  I can accomplish this in MS SQL through a series of inner joins but the resulting dataset is over 2B rows because of the permutations caused by several self joins of xwalk tables.  2B rows is massive overkill and it makes much more sense to send qlik small tables and let it put the associations together itself.  But no matter how many times I try to build this model this Y-Y structure qlik doesn't like.  Is this structure just not allowed in qlik or is there some way I can accomplish this that qlik will allow in a non-recursive manner?

[abhijitnalekar]

HI @dhogan ,

Is it possible to send small chunk of data.

[dhogan]

I cannot as its internal data I can't release.  Is my Y design allowed by Qlik and I likely have a conflict in my data or is it not allowed?  Basically the Y design should do an inner join such that only the results in the table on the far left which match both criteria of the Y design should be shown.  If there is a conflict in that 1 record on the upper path matches but not on the lower path then that record is excluded.  Is that where the Qlik association is getting confused and thinks there is circular logic?