topic AVG() problem in TOTAL EXPRESSION in QlikView

AVG() problem in TOTAL EXPRESSION

Fri, 30 Apr 2010 11:27:06 GMT

Dear All,

I'm getting crazy with it !

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.

Just look to the attachment and last folder u see blank table with column AVGTOT (Total Expression) and AVGAVE (average of figure)

I tried with avg(TOTAL <some fields>... but it doesn't works

Any Idea ?

Thanks

Sergio

AVG() problem in TOTAL EXPRESSION

Fri, 30 Apr 2010 13:18:06 GMT

Try changing the total mode for that expression to Avg OF ROWS in the expressions tab.

AVG() problem in TOTAL EXPRESSION

fernandotoledo — Fri, 30 Apr 2010 13:46:11 GMT

Hi Italian friend!

I see that there are some dates missing.

I think you should bring the difference "Date1-Date2 as DateDif" calculated in script, then use a simple AVG(DateDif) would give the correct result. Treat missing values generates a more complex and less generic chart expression.

hope it helps,

Fernando D'Agosto

AVG() problem in TOTAL EXPRESSION

Sat, 01 May 2010 05:24:39 GMT

Dear Nigel,

The problem it's just that. I've different behavior if in total mode I use Avg of Rows (right result) or Total (wrong result).

But I need to have the same using different classification, so it's seems that some others dimensions is creating me problem getting out a wrong result.

Sergio

AVG() problem in TOTAL EXPRESSION

Tue, 18 May 2010 08:24:19 GMT

Dear all,

Thanks for all your feedback.

As suggested from Fernando I've solved it doing the calculation on script side, avoiding any duplication and dirty data.

Thanks

Sergio