topic Re: Convert Min value into number in QlikView

Convert Min value into number

Fri, 17 Jan 2014 10:55:53 GMT

Hi All,

I have a field in my report which is in min , (Calculated by using the interval function between two timestamp),.

Now i need to convert that value in to integer .

Thanks,

D J

tresB — Fri, 17 Jan 2014 10:58:22 GMT

Minute to integer? you mean minute to hour? if so, then simply, = minute/60 .

Fri, 17 Jan 2014 11:09:00 GMT

Time1	Time2	Time3	Interval(1,2)	Interval(2,3)	Coloumn(4)-Cloumn(4)
12/11/2013 12:20	12/11/2013 12:30	12/11/2013 12:10	10	20	10
12/11/2013 12:30	12/11/2013 12:50	12/11/2013 12:20	20	30	10
12/11/2013 12:50	12/11/2013 12:55	12/11/2013 12:30	5	25	20
12/11/2013 12:40	12/11/2013 12:50	12/11/2013 12:40	10	10	0

This was the exactly what I want , but instead of this I a getting some different vaues in Last coloumn.

Can any one kindly help me on this.

Thnaks

D J

jonathandienst — Fri, 17 Jan 2014 11:11:04 GMT

If your minutes are displayed by Interval(TimeDiff, 'MM'), then multiply by 1440 (24 * 60) to get a value in minutes.

HTH

Jonathan

Edit: eg (Time2 - Time1)*1440

maxgro — Fri, 17 Jan 2014 11:27:24 GMT

this is my result (see attachment)

Regards

CELAMBARASAN — Fri, 17 Jan 2014 11:39:50 GMT

Hi,

While using Interval, it still maintains internally a datetime/time format. Here you need conversion like

Minute(Column(5) - Column(4))

Interval(Column(5) - Column(4), 'm')