7 Replies Latest reply: Jul 3, 2017 12:27 PM by Josh Good Branched from an earlier discussion. RSS

    Selecting Specific Data Based on Date

    Yassine El Mallahi

      Thanks Josh. Great video.

      I am new in qlik and the qlik community really helps me a lot.

      I still have a problem you may help me with.

      I want to get the grade for my date just below the max date for an id ,in the exemple

       

      exemple:

      id:11 ; date : 01/10/2016  ; grade: A

      id: 11 ; date : 13/12/2016 ; grade : B

      id:13 ;  date : 07/04/2016  ; grade : C .....

       

      how to select the date just below the max date for my id 11 ?

       

      thank you in advance

        • Re: Selecting Specific Data Based on Date
          Josh Good

          Hi Yassine,

           

          I branched this to a new thread because it is a new question.  This way other will be able to find it easier.

           

          I'm not clear on what you are trying to do.  You can simply select the date you are interested in and the associated data will be displayed.  However, I'm thinking you want to do something more complex, such as select the second highest date.  Can you post a more detailed example?

           

          -Josh

          Qlik