Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Changing hh:mm to dd:hh:mm date format

Hi guys

I have tried a lot of options for changing hh:mm to dd:hh:mm.

Existing format example

1805:53

That's reading as 1805 hours and 53 minutes.

Need days and hours and minutes combined.

Please help.

Thanks

Tags (1)
6 Replies
antoniotiman
Not applicable

Re: Changing hh:mm to dd:hh:mm date format

Maybe

Interval('1805:53','dd:hh:mm')   -> 75:05:53

Regards,

Antonio

Not applicable

Re: Changing hh:mm to dd:hh:mm date format

Says error in expression so doesn't work.

Chanty4u
Not applicable

Re: Changing hh:mm to dd:hh:mm date format

try this

ta:

LOAD * INLINE [

    name, CALL_DATETIME, sales

    aa,1805:55,100

];

Result:

LOAD *,

trim(date(date(CALL_DATETIME,'hh:mm'),'dd:hh:mm ') )

AS [Call Date]

Resident ta;

frac.PNG

rubenmarin
Not applicable

Re: Changing hh:mm to dd:hh:mm date format

It works for me, and returns the correct result.

In case it has something to do with the formats, try with:

=Interval(Interval#('1805:53', 'hh:mm'),'dd:hh:mm')

sunny_talwar
Not applicable

Re: Changing hh:mm to dd:hh:mm date format

Just to confirm, it worked for me also

Capture.PNG

Not applicable

Re: Changing hh:mm to dd:hh:mm date format

Thanks guys it works great now.Smiley Happy