topic Re: subtract date fileds in QlikView

subtract date fileds

balanandam — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have the data loaded from Mongodb to qlikview, I am unable to subtract data fields like data from other sources ex: MySQL

Start time: 20-04-2018 05:51:34

End time: 20-04-2018 05:43:11

wrote in qlikview as below:

Interval(Timestamp([sessionEndTime],'DD-MM-YYYY hh:mm:ss')-Timestamp([sessionStartTime],'DD-MM-YYYY hh:mm:ss'),'ss') AS Duration

Note: I am using REST connector to read the data from Mongo database and the data format is JSON

Pls. advice.

Br, Balanandam

tresB — Fri, 20 Apr 2018 10:19:46 GMT

Try using timestamp#() instead.

sasiparupudi1 — Fri, 20 Apr 2018 10:22:32 GMT

Interval(Timestamp#([sessionEndTime],'DD-MM-YYYY hh:mm:ss')-Timestamp#([sessionStartTime],'DD-MM-YYYY hh:mm:ss'),'ss') ASDuration

balanandam — Fri, 20 Apr 2018 10:29:53 GMT

Thanks for response, tried this, didn't worked.

Br, Balanandam

balanandam — Fri, 20 Apr 2018 11:05:28 GMT

Hey Sasidhar,

its working. My bad unable to set the format.

Thank You!

Br, Balanandam

sasiparupudi1 — Fri, 20 Apr 2018 11:26:50 GMT

Great, Please close the thread by marking a correct answer