Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
New Contributor III

Latest datapoint before specific date.

Hi,

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?

DateProjectnumberMargin
2017-12-281233,2%
2017-11-231233,0%
2017-09-151233,1%

YearMonth
201711
1 Reply
Highlighted
Contributor II

Re: Latest datapoint before specific date.

Hi,

min(aggr(

if(

min({<date={">=$(filterDate)"}>}date)=date,Margin),date))

attachment