Using Calculated Field Within Same Load to Calculate Missing Data
I have one table which looks like this (ordered by Product&Day field):
Shipments to Stores
The table is essentially a complete historical list of all shipments made to the stores and all sales from the stores. The problem I have is that we do not know what the inventory amount is per day in the stores so I would like to calculate this in Qlikview. Until now I have tried this in my load script but it is telling me the field SOH is not available. I understand that this is because within load scripts you can't reference calculated fields with the same load.