9 Replies Latest reply: Mar 26, 2017 3:55 PM by omar bensalem RSS

    Doubt in Qlik Sense interval Match

    Gulshan Rohilla

      Hi,

      I have question regarding employees table :

       

      EmpID,WefDate,Dept

      1,15/07/2016,HR

      1,01/01/2017,Admin

      2,25/09/2016,HR

      3,25/09/2016,Analytics Developer

      3,01/02/2017,Analytics Sales

      4,01/08/2016,Analytics Sales

      This is the data of the employees w.r.t their departments except 2 and 4 both have changed their departments with time.

      Now we have another of employees details which tells us the DOJ and DOL of an employee :-

       

      EmpID,DOJ,DOL

      1,15/07/2016,-

      2,25/09/2016,31/12/2016

      3,25/09/2016,-

      4,01/08/2016,-

      The - means they are still in the Company so now the Question is

      Show Department Wise Month Wise Head Count Trend Of Employees.......?

       

      Thanks..