topic Re: Apply current value to historic values in QlikView https://community.qlik.com/t5/QlikView/Apply-current-value-to-historic-values/m-p/1160338#M634787 <HTML><HEAD></HEAD><BODY><P>Please have a look at</P><P><A href="https://community.qlik.com/docs/DOC-4310">IntervalMatch and Slowly Changing Dimensions</A></P><P></P><P>it describes in detail how to handle slowly changing dimensions incl. different approaches to solve your request in the script.</P></BODY></HTML> Tue, 17 May 2016 16:20:08 GMT swuehl 2016-05-17T16:20:08Z Apply current value to historic values https://community.qlik.com/t5/QlikView/Apply-current-value-to-historic-values/m-p/1160337#M634786 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>See attached file. In Microsoft NAV there is a table that logs the changing of articles in table: "Item substitution".</P><P></P><P>The current value of a specific item = '55555', but as you can see this item number changed a several times.</P><P>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.</P><P></P><P>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.</P><P></P><P>I think I have to solve this problem with a mapping load and then off course apply this mapping in the facttable.</P><P></P><P>Has anyone an idea how to make this mapping load?</P><P></P><P>Thxs!</P><P></P><P></P><P>Bart Sleegers</P></BODY></HTML> Tue, 17 May 2016 11:14:45 GMT https://community.qlik.com/t5/QlikView/Apply-current-value-to-historic-values/m-p/1160337#M634786 2016-05-17T11:14:45Z Re: Apply current value to historic values https://community.qlik.com/t5/QlikView/Apply-current-value-to-historic-values/m-p/1160338#M634787 <HTML><HEAD></HEAD><BODY><P>Please have a look at</P><P><A href="https://community.qlik.com/docs/DOC-4310">IntervalMatch and Slowly Changing Dimensions</A></P><P></P><P>it describes in detail how to handle slowly changing dimensions incl. different approaches to solve your request in the script.</P></BODY></HTML> Tue, 17 May 2016 16:20:08 GMT https://community.qlik.com/t5/QlikView/Apply-current-value-to-historic-values/m-p/1160338#M634787 swuehl 2016-05-17T16:20:08Z