Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Obtaining closest date in the past for a given date

Hey,

I have Master table with Article, Date and Price [Prices].

On the other hand, I have a table with Article an Date [Transaction]

What I want to do is to get the last known price and date from [Prices] for each article where a [Prices].Date <= [Transaction].Date.

Can anyone help?

Solution will be welcome to solve this in an expression but also with scripting.

Thanks

1 Reply
Highlighted

Obtaining closest date in the past for a given date

You can find a scripting solution in the QV Cookbook example "Fill values in a data range using previous values".

-Rob

http://robwunderlich.com

Community Browser