Get price from second table where date is equel or less than date in first table.

[marteeke]

Hi everyone!

I've got a table with stock-mutations/sales and a table with historic price mutations.
I'm trying to get the right price to go with the mutations/sales.

Feels like i'm close with  '=Max(If(date([InkoopPrijsHistorie.Datum]) <= date([Vrd.Datum]), Prijs))', but this doens't work when the last price isn't the highest..

Any ideas?

Thanks!

[chrismarlow]

Hi,

As a work around If you have disconnected data tables you can possibly use FirstSortedValue similar to below ... I would generally suggest that you should be doing something in script to associate the data properly though.

Cheers,

Chris.

[rwunderlich]

I usually find it easiest to generate a price for each date. For example see

Qlikview Cookbook: Expand A Pricing Date Table https://qlikviewcookbook.com/recipes/download-info/expand-a-pricing-date-table/

-Rob