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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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.