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:
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?