Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show the measure to the most recent date

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

BankDateInterestRate
BNL01/01/20153
BNL30/06/20153,5
BNL30/06/20164
BNL20/09/20161,3
CREDEM01/01/20154,5
CREDEM30/06/20154
CREDEM30/06/20163
CREDEM28/09/20162,8
CREDEM20/09/20161,9
CREDEM01/01/20146
UNICREDIT30/06/20164
UNICREDIT30/06/20152
UNICREDIT01/01/20151

The result should look something like this:

Thanks for your help.

Roberto

1 Solution

Accepted Solutions
Not applicable
Author

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

FirstSortedValue(InterestRate, -Date)

Thanks.

View solution in original post

3 Replies
Not applicable
Author

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

FirstSortedValue(InterestRate, -Date)

Thanks.

sunny_talwar

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)

Not applicable
Author

Thank you so much.