Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
kris_vliegen
Partner - Creator III
Partner - Creator III

Last purchase price

Hi All,

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?

Regards,

Kris

1 Solution

Accepted Solutions
kris_vliegen
Partner - Creator III
Partner - Creator III
Author

Thanks Michele for the answere.

But I've create a from and a to value (date)

And I use now the intervalMatch function.

regards,

Kris

View solution in original post

2 Replies
micheledenardi
Specialist II
Specialist II

Hi Kris,

look at this thread, i think is exatly what you need

Populate column with previous available value.

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
kris_vliegen
Partner - Creator III
Partner - Creator III
Author

Thanks Michele for the answere.

But I've create a from and a to value (date)

And I use now the intervalMatch function.

regards,

Kris