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..
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.
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/