Discussion Board for collaboration related to QlikView App Development.
I have the following table where i have a lot of data structured like below.
I also have an input field where I specify a year and a month.
I need to be able to find the latest margin before the end of the specified date.
With the below selection i would like to get the margin 3,0%.
If I instead change the month to 10 i would like to get 3,1.
I have experimented with:
FirstSortedValue([SP Marginal], [Målkortsdatum], n)
But this only gives me the nth latest margin.
Is there a way to do this?