Discussion Board for collaboration related to QlikView App Development.
I have a input box where user enters the value (seconds), if user enters 180, then it has to convert as 03:00 (as minutes) in input box, i need to use this variable in my expression calculation.
Tried with different option like positive integer, predefined values etc but did not work.
Can any one help me out?
Divide by 60 to convert to decimal minutes or divide by 86400 (24x60x60) to convert to a QV time/interval value which you can then format withe the Interval() format function:
=Interval(yourFieldinseconds / 86400, 'hh:mm')
Thanks Janathan, do i need to keep this expression at custom field in input constraint of Input box?
Actually here i am showing input box and user will enter some value which is in seconds, however it should be converted into mm:ss format while displaying it.
Use the expression where you are displaying it.