topic Re: Wrong average between dates in QlikView

Wrong average between dates

Fri, 18 Oct 2013 18:30:13 GMT

Hello!

I'm desperated and very thankful for everybody who could take a look at my attachment (can find problem and explanation in here).

In one case it is working, but the second one does not although I'm using the same method.

I mean the sum is right, the count is right, but the average isn't...

So many thanks!

Re: Wrong average between dates

Clever_Anjos — Fri, 18 Oct 2013 18:42:42 GMT

Just formatting issue...

or apply

=interval(Sum({<TechDir_CloseDateTimestamp ={"$(=Date(addmonths(Max(TechDir_CloseDateTimestamp), -4), 'MM/YYYY'))"}, TechDir_closure_code=-{'Void'}>} TechDir_TimeToOwn)/

Count({<TechDir_CloseDateTimestamp ={"$(=Date(addmonths(Max(TechDir_CloseDateTimestamp), -4), 'MM/YYYY'))"}, TechDir_closure_code=-{'Void'}>} TechDirect_ID))

=(Sum({<TechDir_CloseDateTimestamp ={"$(=Date(addmonths(Max(TechDir_CloseDateTimestamp), -4), 'MM/YYYY'))"}, TechDir_closure_code=-{'Void'}>} TechDir_TimeToOwn)/

Count({<TechDir_CloseDateTimestamp ={"$(=Date(addmonths(Max(TechDir_CloseDateTimestamp), -4), 'MM/YYYY'))"}, TechDir_closure_code=-{'Void'}>} TechDirect_ID) * 24

Re: Wrong average between dates

Fri, 18 Oct 2013 18:49:11 GMT

Awesome!

Made my day - so many thanks!