topic Re: Avg not as expected in QlikView

Avg not as expected

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

Hi All,

I have a table of stats split by Region / Sub Region/ Sales Person. I am not trying to show the averages in another table by Region but the avg's are different to what i get if i export the first table into Excel .

Can anyone see what i am doing wrong with the attached?

In excel i get 8.2

Re: Avg not as expected

sunny_talwar — Thu, 24 Oct 2019 11:05:22 GMT

Try this expression

=Avg(Aggr( Count(_%Visit)/Count({<[Image Level], [Group Outlet Type]>}DISTINCT [Worked Day]) , Territory, [Sales Rep], Region))

Re: Avg not as expected

hopkinsc — Thu, 24 Oct 2019 11:08:51 GMT

Thanks Sunny, that works!

I have noticed that you have removed the = from the set analysis, was there a reason for that?

Re: Avg not as expected

sunny_talwar — Thu, 24 Oct 2019 11:12:48 GMT

Sorry that is just out of habit. Having FieldName = is equivalent of FieldName. You can add that back.