topic Re: sum time values in QlikView

sum time values

Anonymous — Tue, 05 Jan 2016 06:53:33 GMT

hi,

i have feild that show time 1.36(1hour & 36 minute )

if i write in expression sum(feild1) the result is 5.44 (i have 4 line with that 1.36 )

how do i write to get the result in hour - 6.24 - 6 hour & 24 minute ?

thanks'

yarin.

Re: sum time values

sasikanth — Tue, 05 Jan 2016 06:57:38 GMT

hi,

can you explain a bit more what exactly you want to achieve?

if possible with a sample

Re: sum time values

tamilarasu — Tue, 05 Jan 2016 07:00:26 GMT

Try,

=Time(sum(Num(Time#(FieldName,'hh:mm'))),'hh:mm')

If your hour and minute format is 06.30 then try below,

=Time(sum(Num(Time#(F1,'hh.mm'))),'hh.mm')

Re: sum time values

tresB — Tue, 05 Jan 2016 07:09:27 GMT

Try like:

=Time(Sum(Time#(Field, 'hh.mm')), 'hh:mm')

Re: sum time values

MarcoWedel — Tue, 05 Jan 2016 07:42:37 GMT

‌Interval(Sum(field1)/24,'hh.mm')

Re: sum time values

HirisH_V7 — Tue, 05 Jan 2016 07:45:19 GMT

Hi,

Check this with your time field,

=time(num(time#('00:20', 'hh:mm')) + num(time#('00:30', 'hh:mm')) , 'hh:mm')

So, it may look like this for you:

=time(sum(num(time#(TIME,'hh:mm'))),'hh:mm')

HTH,

-Hirish

Re: sum time values

Anonymous — Tue, 05 Jan 2016 11:34:32 GMT

hi,

i try all the answer and i didn't secceed .

exm:the feild look like this : 1.36

when i calcult sum ( for 4 lines ) i need to see 6.24

1.36 + 1.36 + 1.36 + 1.36 = 6 hour & 24 minute

Re: sum time values

tresB — Tue, 05 Jan 2016 11:41:32 GMT

Wroking with me. Check attached qvw

Re: sum time values

MarcoWedel — Tue, 05 Jan 2016 11:42:13 GMT

Interval(Sum(Interval#(field1,'hh.mm')),'hh.mm')

Re: sum time values

Anonymous — Tue, 05 Jan 2016 11:54:41 GMT

thanks'

yarin

Re: sum time values

fgolmahi — Thu, 11 Nov 2021 20:31:01 GMT

please help me

I could not sum a column.

Thank you for your help

Re: sum time values

tresB — Fri, 12 Nov 2021 05:40:54 GMT

Hi @fgolmahi , I don't have a qv license yet (hoping to get one soon from qlik as an MVP). So can't open your qvw and check what/how you are trying. Please post your expression/ screen shot and expected result w.r.t. the sample data you shared.

Re: sum time values

fgolmahi — Fri, 12 Nov 2021 18:06:14 GMT

Hi, thank you for your help
Yes, I use the server version at work and I have no problem opening files.
If possible, please guide me to the field of the attached file.

my expression is =Time(Sum(time#(timeee, 'h:mm')),'h:mm')

Re: sum time values

fgolmahi — Sun, 14 Nov 2021 05:44:50 GMT

@tresB

Hi, thank you for your help
Yes, I use the server version at work and I have no problem opening files.
If possible, please guide me to the field of the attached file.

my expression is =Time(Sum(time#(timeee, 'h:mm')),'h:mm')

Re: sum time values

tresB — Mon, 15 Nov 2021 05:54:19 GMT

@fgolmahi

I have problem opening the file. I got your expression, now let me know your expected output and what you are getting using the above expression while using the excel data you shared.

Re: sum time values

fgolmahi — Mon, 15 Nov 2021 20:06:11 GMT

Hi @tresB

Yes, I use this expression, but unfortunately it calculates incorrectly and calculates integer.

please help me 😞

for example sum following fields :

05:09

03:32

00:41

05:01

02:44

01:17

00:00

00:40

03:48

03:13

00:48

02:50

05:05

Re: sum time values

tresB — Tue, 16 Nov 2021 05:14:28 GMT

@fgolmahi

While working on timestamp and it's formatting there are important catches and that is the reason I wanted to emphasis on 'your expected output'. I guess you need interval(), something like:

Interval(Sum(time#(timeee, 'h:mm')),'h:mm')

Or, simply

Interval(Sum(timeee),'h:mm')

Re: sum time values

fgolmahi — Tue, 16 Nov 2021 20:56:34 GMT

Thank you for your help. @tresB

Your comments were excellent and I able to get the right answer.

Thank you very much.