Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Apply current value to historic values

Hi all,

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?

Thxs!

Bart Sleegers

Tags (2)
1 Reply
MVP
MVP

Re: Apply current value to historic values

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.

Community Browser