8 Replies Latest reply: Jun 22, 2017 8:18 AM by Thomas Ødegaard RSS

    Number of FTE's remaining

    Thomas Ødegaard

      Hi,

       

      I have a dataset with consultants with a start and end date.

      I would like to visualize how many consultants that are available for each month.

       

      How can this be calculated in Qlik Sense?

       

      So my dataset could look like this:

        

      FTEStartDateEndDate
      101/01/201731/05/2017
      201/02/201731/10/2017
      201/03/201730/09/2017
      101/03/2017

      31/12/2017

       

       

      How can I calculate in Qlik, that I have 1 FTE available in January, 3 in February (as one is hired in January with end date in May and two more are hired in February with end date in October) and so forth?

       

      Result

                                                        

      MonthFTE
      Jan1
      Feb3
      Mar6
      Apr6
      May6
      Jun5
      Jul5
      Aug5
      Sep5
      Oct3
      Nov1
      Dec1
      MonthFTE
      Jan1
      Feb3
      Mar6
      Apr6
      May6
      Jun5
      Jul5
      Aug5
      Sep5
      Oct3
      Nov1
      Dec1

       

       

       

      Sample data is attached

       

      Br,

      Thomas