topic Re: Delay in QlikView

Delay

prabhas277 — Tue, 07 Jul 2015 12:34:12 GMT

Hi experts,

I am working one travel based project in this one KPI like "on time guest pick up" .HOw to calculate the that ont ime guest pickup?

Re: Delay

sunny_talwar — Tue, 07 Jul 2015 12:38:18 GMT

What fields do you have in your database? This is a very open ended question and a open ended answer would be to calculate the difference between 'Time when they are actual picked' - 'Time when they should have been picked'

For a better response, you will have to provide more details.

HTH

Best,

Sunny

Re: Delay

avinashelite — Tue, 07 Jul 2015 12:46:50 GMT

Hi Prabhas,

As sunindia‌ stated , you can calculate the time difference with the help of interval function if it yields 0 then its on time pick up other the other way.

try like this :

interval( A-B, 'D hh:mm' ) where A=97-08-06 09:00:00 and B=96-08-06 00:00:00 returns:


String	365 09:00
Number	365.375

where A and B would be your Pickup and excepted time of pickup