Sum value if Date > today()

[Thijs_Qlik]

Hi all,

I am trying to make a syntax as shown below. I am trying to sum the ours that are planned in the future. So all the ours after today.

if(MAXIMALPRODUCTIONFINISHDATE > Today(), Sum([B_TOTAL_TIME_H:MM:SS]))

but it is not giving a value, any tips or tricks?

#KPI Chart

[PrashantSangle]

Hello

try

Sum(if(floor(MAXIMALPRODUCTIONFINISHDATE )>Floor(Today),B_TOTAL_TIME_H:MM:SS))

Regards,

Prashant Sangle

[Thijs_Qlik]

hi Prashant,

thx for your answer but it is giving me a wrong expression...

am i doing something wrong

[PrashantSangle · Accepted solution]

I missed the () at end of Today.

try below

Sum(if(floor(MAXIMALPRODUCTIONFINISHDATE )>Floor(Today()),B_TOTAL_TIME_H:MM:SS))

Regards

Prashant Sangle

[Thijs_Qlik]

thx a lot!! that worked for me!