Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How would you get rid of this loop?

I have attached a current scenario I have with a data model. There is a loop between three tables:

FISCAL_CALENDAR
FINISHED_GOODS_INVENTORY
INVOICE_ITEM


I know there are few ways of removing this but I'm looking for some guidance on what would be the best practice(s) here when editing the Qlikview load script. Thank you.

1 Reply
johnw
Champion III
Champion III

It seems to me that either invoice date and inventory date are the same date, and should be given a single field name, or they're different dates, in which case they should not be stuck together in a single fiscal calendar. Either makes the loop go away, but I can't be sure that either is appropriate for you.