Discussion board where members can get started with Qlik Sense.
I want to calculate Sum of Time Diff in KPI without using 'Duration' property. Please view snapshot.
I am using this expression:
If I use number formatting as Auto it gives 0.68 i.e. wrong.
I want the result without using Duration. I want the solution using Expression(Formula).
Go to Solution.
May be this
Interval(Sum(If(endtime >= starttime, endtime-starttime, MakeTime(24)-starttime-endtime)), 'hh:mm')
on the screen shot, the TIME DIFF are correct ? if so ? how much would be the correct sum of time ?
If you want to keep it on auto; you'll have to directly format your expression :
Correct SUm of time is 16:19 but it is coming when I use Duration Formating. I want to do with expression