Discussion board where members can get started with Qlik Sense.
I have tried a lot of options for changing hh:mm to dd:hh:mm.
Existing format example
That's reading as 1805 hours and 53 minutes.
Need days and hours and minutes combined.
LOAD * INLINE [
name, CALL_DATETIME, sales
trim(date(date(CALL_DATETIME,'hh:mm'),'dd:hh:mm ') )
AS [Call Date]
It works for me, and returns the correct result.
In case it has something to do with the formats, try with: