topic Re: Average per month in QlikView

Average per month

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

Hi,

I am trying to add a column named average. It must be average of selected month's values. For example, if I choose 5 months, it must be 90,1 as below, bu if I choose 2 months (like Oca and Şub), it must be 138,4 for AB.

My expression formula is shown below.

Could you please help me?

Thank you.

Expression:

=SUM(IF(ATL='ATL',[Fiili Maliyet Tutarı]))/sum(TOTAL<BASKANLIK,MÜDÜRLÜK,ATÖLYE,[skill kod],Kayıt_Donemi_Text,MaliYıl>([Fiili Miktar])*-1)

Re: Average per month

jyothish8807 — Tue, 03 Jul 2018 05:14:42 GMT

For Average, try like this:

=SUM(IF(ATL='ATL',[Fiili Maliyet Tutarı]))/count(distinct MonthField)

Br,

Re: Average per month

fatihtomruk — Tue, 03 Jul 2018 06:52:57 GMT

by adding new straigt table and writing this formula, I managed this problem.

I have Avarage and St.Dev in this table. But I want to extract the min and max values when calculating Standard Deviation. Please help..??

Avg: =avg(aggr((SUM([Fiili Maliyet Tutarı])/sum(([Fiili Miktar])*-1)),BASKANLIK,Kayıt_Donemi_Text))

StDev: =Stdev(aggr((SUM([Fiili Maliyet Tutarı])/sum(([Fiili Miktar])*-1)),BASKANLIK,Kayıt_Donemi_Text))