topic Show the measure to the most recent date in App Development

Show the measure to the most recent date

Sat, 01 Oct 2016 17:08:28 GMT

Hello everyone, I have just started to use Qlik Sense.
I have a problem that i can't solve, I hope someone can help me.

I have a list of banks, interest rate and dates of each change, I am creating a simple histogram display for each bank where its rate the most recent date (the results should be the ones shown in red).

Bank	Date	InterestRate
BNL	01/01/2015	3
BNL	30/06/2015	3,5
BNL	30/06/2016	4
BNL	20/09/2016	1,3
CREDEM	01/01/2015	4,5
CREDEM	30/06/2015	4
CREDEM	30/06/2016	3
CREDEM	28/09/2016	2,8
CREDEM	20/09/2016	1,9
CREDEM	01/01/2014	6
UNICREDIT	30/06/2016	4
UNICREDIT	30/06/2015	2
UNICREDIT	01/01/2015	1

The result should look something like this:

Thanks for your help.

Roberto

Re: Show the measure to the most recent date

Sun, 02 Oct 2016 17:35:23 GMT

I may have solved, but I would to be sure:

FirstSortedValue(InterestRate, -Date)

Thanks.

Re: Show the measure to the most recent date

sunny_talwar — Mon, 03 Oct 2016 20:31:19 GMT

Yes, this is what you need to use here. You can look here for more details on this function

Value Associated with Min/Max Value of Another Field (Front End Solution)

Re: Show the measure to the most recent date

Mon, 03 Oct 2016 21:32:37 GMT

Thank you so much.