This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I was thinking if this is possible , this time stamp "4:44:30" would give something like this "4.44" in numeric value
Thanks for the output guys!,
just solve this on my personal research on math equations
Convert time stamp into hour decimal value :
hour( interval(([time_stamp]/86400), 'hh:mm:ss') )
((Minute (interval(([time_stamp]/86400), 'hh:mm:ss')) * 100) / 60)
+ (Second (interval(([time_stamp]/86400), 'hh:mm:ss')) * 100) / 3600
) / 100
View solution in original post
Use Date#() function...
Try this in a textbox: =time(floor(Time#('4:44:30','hh:mm:ss'),1/1440),'hh:mm:ss'). If that does what you want you can change the last hh:mm:ss in hh:mm to set the time display format to hours and minutes again.
If you want a numeric value of 4.44 from your time value, try (with a standard time format set to 'hh:mm:ss' in the script):
This doesn't make much sense to me, though. Maybe you want the numeric value as fractions of an hour, i.e.
which returns 4.74, i.e. 4 hours and almost three quarters of an hour (seems ok, close to 4:45:00).
If you want just a different text format of your time stamp, use one of the expressions suggested above or
for a decimal point as hour/minute separator.
Can we use multiple aggregation function in time formatting.. I am trying below -:
=interval(timestamp#(((100719)/6), 's'), 'hh:mm:ss')
it is not working - please help me on this.
This doesn't work because 100719/6 produces a number with decimal and that can't be parsed using only 's'. Try to reduce the number to an integer by using floor()/ceil() like:
=interval(timestamp#(floor(100719/6), 's'), 'hh:mm:ss')
What do you mean with multiple aggregation function? I don't see a single aggregation function in your expression.
24*60*60 is the number of seconds in a day (so you convert your seconds to fractions of days, that's what interval() expects.