3 Replies Latest reply: Jan 31, 2012 4:57 AM by Paul Damen RSS

    Comparing data between months

    Paul Damen

      Hello all,

       

      I have a staff file. What I want to do is see the number of new hires and people that leave per month. The data is an excel file with names, staff numbers etc. So what I want is compare the staff numbers and see if a staff number has left in the next month and then name this on, exit or something.

      Same I want to do look a month back and see if the number then existed and name that one hired.

       

      In the excel file they look it up with a Vlookup and see if the number existed in the previous month but I am not sure how to make this possible in qlikview.

       

      I attached the file, hopefully it is clear what I mean.

       

      Kind  regards,

       

      Paul