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


      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

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