3 Replies Latest reply: Oct 3, 2016 5:32 PM by Roberto Mandelli RSS

    Show the measure to the most recent date

    Roberto Mandelli

      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