Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-12-13 09:35 AM

Curren time (at present time) - arrival time calculation

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,

kv  

313 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2012-12-13 09:39 AM
Author

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

233 Views
0 Likes