'Count' between dates

Anonymous — Mon, 23 Nov 2015 09:57:06 GMT

Hi guys,

For the sample data attached, which labels are:

censo_emp

Fecha

ffin_emp

valor

where 'censo_emp' is the employee number, 'Fecha' is the employee starting date and 'ffin_emp' the employee finishing date, I need to get the acummulated count of FTE in every month,

" FTE at the Date" must be the accummulated count of the field 'censo_emp' between the minimum 'Fecha' available and every month until the maximum month selected.

Month	feb	jun	jul	ago	nov
FTE at the Date	4	1	1	1	1

I've been trying with quite a few dataset formulaes for filtering between dates, but I just get the started in every month or the accummulated value repeated in every month.

Txs you for your help.

Juan Carlos.

topic 'Count' between dates in QlikView

'Count' between dates