Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I have an expression which returns a very large number of hours and minutes e.g.
8124282:42
I want to format this like
8,124,282:42
Is there a way to achieve this with the interval format?
The interval format does not seem to accept a thousands sep. The workaround I can think of is to format as interval, reinterpret as number, and add the commas. I added a replace to get ':' before the minutes.
=replace(num(num#(interval(now(2) - MakeDate(2000,1,1), 'h.m')),'#,##0.00'),'.',':')
// returns 170,153:13
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com