Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Wrong average between dates

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!

1 Solution

Accepted Solutions
Employee
Employee

Re: Wrong average between dates

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))

OR

=(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

2 Replies
Employee
Employee

Re: Wrong average between dates

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))

OR

=(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

Not applicable

Re: Wrong average between dates

Awesome!

Made my day - so many thanks!

Community Browser