topic Re: Wrong Avg in linechart in QlikView

Wrong Avg in linechart

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

Hi i have a linechart what counts with the wrong quantity. It counts with sum of rows, instead of expression total.

I included an example over all weeks, i wanna count with 190 instead of 210

Re: Wrong Avg in linechart

sunny_talwar — Fri, 13 May 2016 11:19:03 GMT

Which object are we talking about here?

Re: Wrong Avg in linechart

Kushal_Chawda — Fri, 13 May 2016 11:21:41 GMT

Use Aggr function to aggregate the value for particular dimension

Re: Wrong Avg in linechart

francisvandergr — Fri, 13 May 2016 11:25:53 GMT

linechart avg sales is wrong. Total rows of chart Details has 190 rows

Re: Wrong Avg in linechart

francisvandergr — Fri, 13 May 2016 11:27:05 GMT

I used this formula:

=rangesum(above(sum( {$<Project_Projectleider = {'*'}-{'Bert Schilt'}>} Meerwerk_Bedrag ) , 0 ,RowNo() ) +
rangesum(above(sum( {$<Project_Projectleider = {'*'}-{'Bert Schilt'}>}Project_Aanneemsom ) , 0 ,RowNo() )))
/
Aggr(
Rangesum( Above( count(distinct(if(Project_Aanneemsom > '0' or Project_Aanneemsom < '0' or Meerwerk_Bedrag > '0' or Meerwerk_Bedrag < '0' ,Project_Code))),0,rowno() ))
,Week)

Re: Wrong Avg in linechart

sunny_talwar — Fri, 13 May 2016 11:30:02 GMT

What are the expected number on the chart?