topic Re: Wrong AVG in Chart in QlikView

Wrong AVG in Chart

francisvandergr — Wed, 25 Nov 2020 16:16:04 GMT

I have no good result for an avg when i count with 2 columns

I included an example.

Can someone help

Re: Wrong AVG in Chart

swuehl — Fri, 13 May 2016 09:50:55 GMT

Try this as expression for Avg:

=[Total Amount]

Rangesum(Above(count(if(Project_Aanneemsom > '0' or Project_Aanneemsom < '0' or Meerwerk_Bedrag > '0' or Meerwerk_Bedrag < '0' ,Project_Code)),0,Rowno()))

Re: Wrong AVG in Chart

sunny_talwar — Fri, 13 May 2016 09:51:17 GMT

Check the attached

Change the expression for Qty from full accumulation to no accumulation and used the RangeSum(Above()) expression

RangeSum(Above(count(if(Project_Aanneemsom > '0' or Project_Aanneemsom < '0' or Meerwerk_Bedrag > '0' or Meerwerk_Bedrag < '0' ,Project_Code)), 0, RowNo()))

Re: Wrong AVG in Chart

swuehl — Fri, 13 May 2016 10:11:01 GMT

If you want to keep your totals, maybe use a Qty expression like

=FirstsortedValue(

Aggr(

Rangesum( Above( count(if(Project_Aanneemsom > '0' or Project_Aanneemsom < '0' or Meerwerk_Bedrag > '0' or Meerwerk_Bedrag < '0' ,Project_Code)),0,rowno() ))

,Week)

, aggr(-Week,Week)

)

or if your Qty line values can't be negative, maybe just

=Max(

Aggr(

Rangesum( Above( count(if(Project_Aanneemsom > '0' or Project_Aanneemsom < '0' or Meerwerk_Bedrag > '0' or Meerwerk_Bedrag < '0' ,Project_Code)),0,rowno() ))

,Week)

)