Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.