Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
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

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