I need to show value (second) in this format (hh:mm:ss)in a Qliksense chart ? it doesn't give the right results instead of 00:21:13 it shows 51234:04:01 .
Thank you in advance
Try this may be:
Are you using any formatting when you see 51234:04:01? or is this how it is coming directly from your database? If you are using a formatting what is it and what do you see when you remove the formatting (direct database output)?
Hi, if your input data is in seconds you need to tell this to qlikview (as for QV 1=1 day):
Time(Time#(secondsValue, 's'), 'hh:mm:ss')
Time(secondsValue/86400, 'hh:mm:ss') //There are 86400 seconds in a day
what's your value numeric
I did find the solution to my problem, basicly in the expression area you should put
Interval(value/(24*60), 'hh.mm.ss') , value being in minutes
and in the Number formating area of the chart you should choose Time and customize the format the way you want.
Retrieving data ...