Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
qlikconsultant
Contributor II

I need only the days and hours stored

I have the following Code in the load script:

interval(Endtimestamp-Starttimestamp,'DD-hh') as Timedifference

How can i save the Timedifference only as DD:mm?

2 Replies

Re: I need only the days and hours stored


Hi,

try

interval(Endtimestamp-Starttimestamp,'DD:mm')

or

interval(Endtimestamp-Starttimestamp,'hh:mm')

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
mark6505
Valued Contributor III

Re: I need only the days and hours stored

Hi

Wrap in he timestamp function.

Timestamp(Now(),'DD:mm')

either the expression or as proceeding load.

Mark

Community Browser