topic How to add integer to Time (Minutes)? in QlikView

How to add integer to Time (Minutes)?

Mon, 08 Nov 2010 20:32:00 GMT

Hi guys, Need some help...

I am trying to solve the following...

,Num(Mid(Time(WorkStart,'hh:mm'),4,2)) + Num(DateMinutes) as x2

where:

Time(WorkStart,'hh:mm') is equal to 07:00

DateMinutes is equal to 600

The result I am looking for is: 0+600 = 600 Instead I get 0.41666666666667

How do I work it around?

Thanks in advance,

Aldo.

How to add integer to Time (Minutes)?

johnw — Mon, 08 Nov 2010 20:40:02 GMT

I don't understand the question, but times are stored as fractions of a day. So 12 hours is stored as 0.5. 600 minutes is 0.41666666... days. So is your DateMinutes field actually an interval (also in fractions of a day) instead of an integer number of minutes?

In any case, if you want to add one to the other, they'll need to be the same sort of measurement, either fractions of a day or number of minutes or whatever.

How to add integer to Time (Minutes)?

Mon, 08 Nov 2010 20:44:38 GMT

=num(Timestamp(0.41666666666667) ) * 24 * 60

How to add integer to Time (Minutes)?

Tue, 09 Nov 2010 21:44:59 GMT

I am still checking it. I'll let you know.

Aldo.

How to add integer to Time (Minutes)?

Wed, 10 Nov 2010 17:50:58 GMT

Hi Nick, based on your suggestion, I used:

,Date(RangeSum(Peek(WorkDateSequence),Num(TimeStamp(DateMinutes))),'DD/MM/YYYY hh:mm') as WorkDateSequence

Thanks,

Aldo.

How to add integer to Time (Minutes)?

Wed, 10 Nov 2010 18:04:47 GMT

Maybe you don't need to use TimeStamp function if your DateMinutes field has Date/TimeStamp type. I used the TimeStamp function just to convert number to timestamp for reproducing your example.

How to add integer to Time (Minutes)?

Wed, 10 Nov 2010 18:26:27 GMT

Yeap! you are right, Thanks.