Discussion Board for collaboration on QlikView Scripting.
See attached file. In Microsoft NAV there is a table that logs the changing of articles in table: "Item substitution".
The current value of a specific item = '55555', but as you can see this item number changed a several times.
What I want to do is to apply the current value of the item (55555) to all historic values to use for example in de orderline history.
In this way I can get the total amount of turnover of the item including all mutations with other item numbers from the past, because the item number was differtent in the past.
I think I have to solve this problem with a mapping load and then off course apply this mapping in the facttable.
Has anyone an idea how to make this mapping load?
Please have a look at
IntervalMatch and Slowly Changing Dimensions
it describes in detail how to handle slowly changing dimensions incl. different approaches to solve your request in the script.