topic Re: AVG in QlikView

AVG

NavinReddy — Thu, 27 Mar 2014 13:02:44 GMT

Dear All,

I am Calculating Avg for based on Users,But users are repeating that's why im using Standard id
here im calculating User AVG Per Year
These two expression im using
But i am getting Different values ,Please correct some on where im wrong

=avg(aggr(sum(PAY_AMT),[Standard Id],(Month)))=581.15
=Sum( PAY_AMT ) /Count(TOTAL [Standard Id] )=530.45

Thanks In Advance
Niranjan

Re: AVG

MK_QSL — Thu, 27 Mar 2014 13:04:27 GMT

Try DISTINCT instead of TOTAL

=Sum( PAY_AMT ) /Count(DISTINCT {1} [Standard Id] )

Or please provide sample file or apps.

Re: AVG

NavinReddy — Thu, 27 Mar 2014 13:12:32 GMT

Hi Manish,

yes i tried but not working thank you

Regards,

Niranjan

Re: AVG

MK_QSL — Thu, 27 Mar 2014 13:24:05 GMT

Can you provide sample data?

Re: AVG

NavinReddy — Thu, 27 Mar 2014 13:47:57 GMT

Hi Manish,

please find sample data

S Id	Employee Name	P_AMT	Year
11765	H	230	2014 01
11765	H	56	2014 02
53150	S	892	2014 01
53150	S	12	2014 02
23203	A	457	2014 01
23203	A	20	2014 02
23748	I	562	2014 01
23748	I	406	2014 02

Regards,

Niranjan

Re: AVG

MK_QSL — Thu, 27 Mar 2014 14:31:09 GMT

Check enclosed file..

Let us have brief description about your requirements.

Re: AVG

NavinReddy — Thu, 27 Mar 2014 16:05:10 GMT

Thanks so much Manish..