Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I may have solved, but I would to be sure:
FirstSortedValue(InterestRate, -Date)
Thanks.
I may have solved, but I would to be sure:
FirstSortedValue(InterestRate, -Date)
Thanks.
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)
Thank you so much.