AVG Function

[#1]

Dear Guys,

I'm getting crazy with an easy request, but I'm new to qlikview.

I've OrderTable with Header and Position and I'm just calculating the lead time (GoodIssueDate - InsertOrderDate) grouping it by country.

Basically I need to have an avg lead time calculation :

And I put an expression Avg(GoodIssueDate - InsertOrderDate) and it works if I select "Average" under "Total Mode" on the Expressions tab

If I select Total Expressions it give me wrong result. Problem is that if I have all the line orders items result is ok, if I have it grouped by country it give me a wrong result.

Any Idea ?

Thanks

Sergio

[#2]

Dear all,

Thanks for all your feedback. I've solved it doing the calculation on load side, so it avoid any duplication and dirty data.

Thanks

Sergio