Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Time difference between two timestamps


Hi All,

Kindly help me to resolve the difference between two timestamps

Ex:

      column 1 :  2013-05-17 22:14:15

      column 2:   2013-05-17 22:20:15

Tried out the following option (Mentioned earlier in the community but it didnt work ,returns no value)

 

=

Interval(NUM(Date#(finished, 'DD-MM-YYYY hh:mm:ss tt')-num(Date#(started, 'DD-MM-YYYY hh:mm:ss tt'))))

Thanks in advance

1 Reply
Employee
Employee

Re: Time difference between two timestamps

dont use tt since your using 24h period and adjust you date format

Interval(NUM(Date#(finished, 'YYYY-MM-DD hh:mm:ss')-num(Date#(started, 'YYYY-MM-DD hh:mm:ss'))))

Community Browser