Discussion Board for collaboration on QlikView Scripting.
Attached is a sample qvw file with sample data and the circular loop.
What could be done in data model to avoid it ?
Could someone guide me in the right direction ?
Many thanks in advance.
Remove the table:
/*[Sales network-Item category]:
LOAD * INLINE [
Sales network, Item category,
as it is a linking table but all the table are already linked without it.
I need that table because a sales network can sell only items of categories linked.
What about this Data Model ?
did you merge four tables into one?
I don't think it's could works for my requirements.
specially because the end user has an input date (MM/DD/YYY) to submit and should be able to see what happened at that date, to what sales network and item category the sales agent belonged to.
You say 'the end user has an input date (MM/DD/YYY) to submit and should be able to see what happened at that date'
I somehow suspect you'll need to create a SCD [Slowly Changing Dimension] table quite likely by exploiting IntervalMatch().
Are there any other requirements not mentioned in your original question ?
if you want all tables with association better to cut association between two tables it will go out loops.
Thanks to all for your quickly reply.
Finally I decided to rename the field "Item category" of table "Sales network-Item category" to "Network category".
In this way I can show in UI both dimensions in order to check if the sales agent sold items that he should not.
If you want some reading on circular references and how to solve them, take a look at Circular References.
Comment out any one of the same field name that is appearing in two different tables which is causing the circular refeence