topic Re: Waiting Time in QlikView

Waiting Time

Anonymous — Mon, 19 Oct 2015 19:42:12 GMT

The above straight tables show time between two consecutive transaction (TimeDispensed) with a unique id ScriptNumber. The difference between the tables is the DateDispensed and Month-Year Dispensed. I tried calculating the wait time (TRx Wait Time), time between two consecutive transactions, with the following expression:

=(Interval(([TimeDispensed]) - Below([TimeDispensed])),'mm : ss')

but this gives blanks as the above table shows. How can i resolve this and then calculate the monthly average "TRx Wait Time" and graph the average monthly wait time against Month-Year?

Regards.

Re: Waiting Time

prabhu0505 — Mon, 19 Oct 2015 20:01:20 GMT

Try something like this.

=Interval((Time#('8:10:20', 'hh:mm:ss') - Time#('9:00:10', 'hh:mm:ss')),'hh:mm:ss')

=Interval((Time#([TimeDispensed], 'hh:mm:ss') - Time#(Below([TimeDispensed])), 'hh:mm:ss')),'hh:mm:ss')

Re: Waiting Time

Anonymous — Mon, 19 Oct 2015 20:03:54 GMT

try this expression

=Interval(([TimeDispensed]) - below([TimeDispensed]),'mm : ss')

it works for me, your expreion also showed "-"

the difference is that i use additional brackets around ([TimeDispensed]) - below([TimeDispensed]))

Re: Waiting Time

Anonymous — Mon, 19 Oct 2015 20:30:13 GMT

Many thanks, tried but gave me an expression error

Re: Waiting Time

Anonymous — Mon, 19 Oct 2015 20:31:05 GMT

Many thanks, this seems not to be working for me.

Re: Waiting Time

prabhu0505 — Mon, 19 Oct 2015 20:37:12 GMT

share the application, if possible.

Re: Waiting Time

Anonymous — Mon, 19 Oct 2015 20:47:26 GMT

i used an inline table without "AM"

now I changed it. my inline table is

TEST:
Load * Inline [
TimeDispensed
8:00:00 AM
8:10:00 AM
];

Expression in straight table is:

=Interval((time((time#([TimeDispensed],'h:mm:ss TT'))) - below(time(time#([TimeDispensed],'h:mm:ss TT')))),'mm : ss')

table Looks like (value is negative as Expression subtract 8:10 from 8:00!

Re: Waiting Time

prabhu0505 — Mon, 19 Oct 2015 21:38:25 GMT

To accommodate AM/PM, use below format-code.

=Interval((Time#('8:10:20 AM', 'hh:mm:ss tt') - Time#('9:00:10 AM', 'hh:mm:ss tt')),'hh:mm:ss')

Re: Waiting Time

Anonymous — Mon, 19 Oct 2015 22:20:27 GMT

Thank you Saravana