Discussion Board for collaboration related to QlikView App Development.
I have a table with a purchase price by article by vendor and with a start date of that price.
So It could be that we by one product on several(two) places at the same day.
The price is value till the record with the next date for that article.
We also have a table with the data of sales.
Now I would like to get the correct purchase price on every salesline.
How can I do this best in the script?
Thanks Michele for the answere.
But I've create a from and a to value (date)
And I use now the intervalMatch function.
View solution in original post
look at this thread, i think is exatly what you need
Populate column with previous available value.