topic Re: Sum (ReportedTime) / 60 in QlikView

Sum (ReportedTime) / 60

Sun, 04 Nov 2012 21:14:00 GMT

Dear all,

I ask for help, I'll try to explain, I do not understand the programming,

and I have a slow IT, how many of what I understand to get the wrong information about a time that we needed

for some time spent getting

1,78

I get the correct time, If I have multiply

"1,78" = 1 h + 0.78 x 60 min = 1 hour and 46.8 minutes

what QlikView uses the Sum (ReportedTime) / 60

Is there anything that you type and automatically shows me the time of 1h 46min

QlikView uses version 8:01

Re: Sum (ReportedTime) / 60

swuehl — Sun, 04 Nov 2012 21:25:08 GMT

Try

=time(1.78 *maketime(1))

=interval(sum(ReportedTime) *maketime(1))

Hope this helps,
Stefan

Re: Sum (ReportedTime) / 60

Mon, 05 Nov 2012 20:59:30 GMT

Unfortunately does not show me the good values

what else do we have the formula

Sum (CalcTimeInMinutes)/60

and

Sum (ReportedTime) / 60

Re: Sum (ReportedTime) / 60

swuehl — Mon, 05 Nov 2012 21:33:38 GMT

Sorry, I am a little bit confused.

I assumed your 1,78 is giving the time in hours. So 1,78 (or 1.78 in legal decimal point notation for QV internal use), equals to 1 hour 46 minutes and 48 seconds. This is what my expression

=interval(1.78 *maketime(1))

does return, doesn't it?

If instead 1.78 is giving the time in minutes and its fraction, just use

=interval(1.78 *maketime(0,1))

edit: and if your values may be larger than 24 hours resp 60 minutes, you need to use interval() instead of time() function. Changed that.

Re: Sum (ReportedTime) / 60

Mon, 05 Nov 2012 22:54:54 GMT

Thanks for the effort in the first

for example ...

The time base is showing 468.00

using QlikView with formula Sum (ReportedTime) / 60

I get this 7.80

and to calculate how many hours a minute, I have the following manner

7 h and 80 * 0.60 = 48min = 7:48

for example, if you enter this

= interval (sum (ReportedTime) maketime * (1))

I get this 19.50

Re: Sum (ReportedTime) / 60

swuehl — Tue, 06 Nov 2012 08:17:02 GMT

Your time base (e.g. 468.00) is in what unit? Hours*60?

If you need to divide sum(ReportedTime) by 60 to get your hours, you'll need to do this also in my expression:

= interval (sum(ReportedTime) /60 * maketime(1) )

maketime() is a function, 1 being an argument, so don't use maketime *(1), but maketime(1)

Re: Sum (ReportedTime) / 60

Wed, 07 Nov 2012 19:52:16 GMT

Unfortunately that does not work ... do not bother you anymore ... I gave IT so I'll wait ...

thanks a lot for your help.