Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Check_verify_values month to month

Hello guys!

I dont know how to calculate:

  • Fires
  • New Hires

I have 2 tables (A & B)

Table A (People and Projects)

ID          Project

AA          alfa

BB          Beta

CC          Gamma

DD         Epsilon        

Table B (Date and Project)

  Date    Project

    Jan                Alfa

    Jan                  Beta

    Jan                  Gamma

    Feb                  Alfa

    Feb                    Beta

   Feb                    Epsilon


I would like to Know the new hires and the fires  for each month


So in february the guy " CC" doesnt work and the guy "DD" is the new hire in the team (1 hire + 1 fire)


I would like to grapgh the hires and the fires due to are the same people working in both months but are different people



Help me please!!!!

0 Replies