Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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)