topic Input box value conversion in QlikView

Input box value conversion

sridhar_sigired — Tue, 18 Oct 2016 04:42:00 GMT

Hi,

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?

Re: Input box value conversion

jonathandienst — Tue, 18 Oct 2016 04:56:50 GMT

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')

Re: Input box value conversion

sridhar_sigired — Tue, 18 Oct 2016 05:05:43 GMT

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.

Re: Input box value conversion

jonathandienst — Tue, 18 Oct 2016 05:13:03 GMT

Use the expression where you are displaying it.