topic Re: Convert Minutes/Hours to number in QlikView

Convert Minutes/Hours to number

apthansh — Wed, 25 Nov 2020 16:16:04 GMT

Hi - I have hours in the below format.When I do sum of hours I get zero.Do I have to convert this format ??

Thanks much.

Anil_Babu_Samineni — Mon, 26 Mar 2018 13:26:39 GMT

Simply Num(FieldName) not working for you?

I mean Sum(Num(FieldName)) is not working for you?

sunny_talwar — Mon, 26 Mar 2018 13:36:34 GMT

Yes, it would be better if you use Interval() on top of Sum()

Interval(Sum(...), 'D hh:mm:ss')

sasiparupudi1 — Mon, 26 Mar 2018 13:37:18 GMT

Sum(Time(Time#(YourField,'hh:mm'),'hh'))

apthansh — Mon, 26 Mar 2018 15:11:40 GMT

Thank you all but all these expressions are giving me 3 in Qliksense where as 13 in Qlikview with the same expression.

Should be same in both correct ?

sunny_talwar — Mon, 26 Mar 2018 15:13:54 GMT

Without seeing qvw and qvf... it would be difficult to say... but the difference could be because of many different things. Just to list few

1) Different field formats

2) Different soruces

3) Different data

4) Different expressions

5) Different environmental variables

etc etc....

jmvilaplanap — Mon, 26 Mar 2018 15:27:43 GMT

Hi,

Probably you must to convert the time to number with "time#(field, 'hh:mm')", try this.

apthansh — Mon, 26 Mar 2018 15:46:42 GMT

stalwar1‌ - I have attached the source file ,QVW & QVF ....

sunny_talwar — Mon, 26 Mar 2018 15:52:05 GMT

With slight modifications in the script... I am seeing the same result

apthansh — Mon, 02 Apr 2018 13:20:49 GMT

As always you are awesome

apthansh — Mon, 02 Apr 2018 13:21:16 GMT