Curren time (at present time) - arrival time calculation

Thu, 13 Dec 2012 14:35:20 GMT

Hi everyone,

My table looks like this:

Name Arrival_time

peter 12/12/2012 04:10:45

andrew 12/12/2012 10:45:20

John 12/12/2012 09:30:52

I am planning to create a pivot table and calculate the time difference between the current time and the arrival time and display the difference of time. It is for sure not a straight subtraction because as the day passes by, the difference between the current time and the arrival time increases.

It would be great if someone can help me out on this please.

Regards,

Re: Curren time (at present time) - arrival time calculation

Anonymous — Thu, 13 Dec 2012 14:39:59 GMT

Koushik,

Using difference is fine, but:

If you use now() or now(1) for the current time, it will be recalculating every second, and use a lot of CPU. not a good idea.

You can use now(2) - it is the time te document was open, or now(0), the time when it was reloaded.

Regards,

Michael

topic Curren time (at present time) - arrival time calculation in QlikView

Curren time (at present time) - arrival time calculation

Re: Curren time (at present time) - arrival time calculation