topic Re: Convert Time to Integer in QlikView

Convert Time to Integer

rustyfishbones — Thu, 31 May 2018 12:12:34 GMT

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.

Re: Convert Time to Integer

marcus_sommer — Thu, 31 May 2018 12:22:09 GMT

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

Re: Convert Time to Integer

sunny_talwar — Thu, 31 May 2018 12:27:54 GMT

May be this

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

Re: Convert Time to Integer

rustyfishbones — Thu, 31 May 2018 12:33:25 GMT

that returns 62004710.6

Re: Convert Time to Integer

sunny_talwar — Thu, 31 May 2018 12:37:19 GMT

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

Re: Convert Time to Integer

yashdeep — Thu, 31 May 2018 13:01:45 GMT

You can use interval function :

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