Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
sridhar_sigired
Contributor

Input box value conversion

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?

3 Replies
Highlighted
MVP
MVP

Re: Input box value conversion

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
sridhar_sigired
Contributor

Re: Input box value conversion

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.

Highlighted
MVP
MVP

Re: Input box value conversion

Use the expression where you are displaying it.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein