Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master II
Master II

Convert Time to Integer

Hi All,

I have the following

=TIME('$(now)' - TIME(MIN({<[TrxType] = {'D'},ActionID = {'PICKCASE'}, FromChamber = {'PR'}>}StartTime),'hh:mm'),'hh:mm')

which returns 04:10

I need to covert this to a number, can you help.

5 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Just remove the time() functions from your expression because each math operation with date/time field will just return the numerical value and not be treated any longer as dual-value. If you need a special formatting, for example to define the decimal-delimiter you need to use num() for it.

- Marcus

Highlighted

May be this

=('$(now)' - MIN({<[TrxType] = {'D'},ActionID = {'PICKCASE'}, FromChamber = {'PR'}>}StartTime)) * 1440

Highlighted
Master II
Master II

that returns 62004710.6

Highlighted

Well I was not sure what you wanted initially, but now I do... and I guess you already got the solution on your other post

Highlighted
Contributor III
Contributor III

You can use interval function :


Interval('$(now)' - TIME(MIN({<[TrxType] = {'D'},ActionID = {'PICKCASE'}, FromChamber = {'PR'}>}StartTime),'hh:mm'),'mm')