Skip to main content
Announcements
Join us on Sept. 17 to hear how our new GenAI Assistant empowers data professionals: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Rydderski1
Contributor
Contributor

Sum Value per Month betweet Startdate and Enddate

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.

 

 

 

Labels (7)
1 Reply
G3S
Creator III
Creator III

you could try

 if(stardate>=MonthField and targetdate<=MonthField, sum(FTE_IT),0)