6 Replies Latest reply: Sep 29, 2016 1:09 PM by Nicole Scotti RSS

    Keep last record per date, per person

    Nicole Scotti

      Hello, I am having a little trouble filtering my data.. I have titles for employees by month. If someone's title changes in a certain month, I want only one of the records ( I don't care if it's the first or the second). I can't seem to figure out how to do this. Below is a screenshot of what I am referring to.

       

      Thank you!

       

      Qlik Question.PNG