Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

mario-sarkis
Contributor II

waiting time

Dear all ,

i found it the waiting time using the interval Function but as you can See 'AM' shows in the waiting time how can i erase it ?

Starting Time   Ending Time   Waiting Time

07:42:35:90     07:43:57:89    0:01:22 AM

Waiting Time 

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: waiting time

specify a time format as second parameter in the interval function: interval([Ending Time]-[Starting Time],'h:mm:ss')


talk is cheap, supply exceeds demand
2 Replies
MVP & Luminary
MVP & Luminary

Re: waiting time

specify a time format as second parameter in the interval function: interval([Ending Time]-[Starting Time],'h:mm:ss')


talk is cheap, supply exceeds demand

Re: waiting time

Hi Mario, you can add a format to the interval, ie:

interval(timefield, 'hh:mm:ss')

Also, in number tab of graphics you can change the format.

Community Browser