Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
i am currently working on a excel file which is connected to Qlik Sense.
My goal is a visualisation of SUM (FTE IT) for each month where a project is running.
For this exmaple:
August 22 FTE IT = 2.30
September 22 FTE IT = 2.2 and so on...
If anyone could help, I would be very grateful.
you could try
if(stardate>=MonthField and targetdate<=MonthField, sum(FTE_IT),0)