Divide time value with time value

Fri, 29 Jan 2010 13:12:41 GMT

I am trying to divide one Time value with another Time value but QV retuns the wrong answer

I use this expression in my calculation
Time((sum(POPITI * DJMAQT)/1000)) / Time((max(DJRGDT_TM_Timestamp) - min(DJRGDT_TM_Timestamp) - sum(OprTime)))

But if I split the 2 Time values different parst then I get the right answer
Time((sum(POPITI * DJMAQT)/1000)) then will QV return -> 00:18:39 as expected
and when I use
Time((max(DJRGDT_TM_Timestamp) - min(DJRGDT_TM_Timestamp) - sum(OprTime))) then will QV return -> 01:06:15 as expected

But when I try to divide the to fields in QV in one calculation then I get the wrong strange answer -> -0,006633...?!?

The right decimal answer should be 00:18:39 / 01:06:15 > 0,281509 (tested in MS Excel)
(the answer is an KPI figure count for our company)

Thanx for any replies
// Daniel

Divide time value with time value

Sat, 30 Jan 2010 03:04:03 GMT

hi,

can you post an example

Nimish

Divide time value with time value

sathishkumar_go — Sat, 30 Jan 2010 07:27:06 GMT

Hi Daniel

Can u share any example for ur data format.

-Sathish

Divide time value with time value

Fri, 05 Feb 2010 17:44:37 GMT

Hi
I manage to solve the problem,. It was related to the database relations that created the problem.

topic Divide time value with time value in QlikView

Divide time value with time value

Divide time value with time value

Divide time value with time value

Divide time value with time value