Discussion board where members can get started with Qlik Sense.
I have a measures like below all the result showing in seconds I want to display as hr's I tried below but not getting the exact result
2) =if(ElapsedTime>=Urgent and ElapsedTime<=Critical,ElapsedTime-Urgent,Null())
3)=if(ElapsedTime>=Normal and ElapsedTime<=Urgent,ElapsedTime-Normal,null())
I tried like //=num(floor( (ElapsedTime-[Critical])/3600,'##.##') how to get exact format like only I need 1139,1139,783, like in all 3 expresions how to include?
it is showing
Maybe remove the Num() function with the '##.##' formatting just leaving something like this
floor( 123456 / 3600 )
Not working same result it is giving
Use interval function to get results as hours.
How about this:
interval('2.5555','hh:mm') or interval('2,5555','hh:mm') based on your system variables.
Result = 61:19
for second expression how can I include the interval?
=if(ElapsedTime>=Urgent and ElapsedTime<=Critical,interval(ElapsedTime-Urgent,'hh:mm'),Null())