Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor III

Average per month

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)

asdasd.PNG

2 Replies
Highlighted
Honored Contributor II

Re: Average per month

For Average, try like this:

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


Br,

KC

Best Regards,
KC
Highlighted
New Contributor III

Re: Average per month

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))

asdsasdas.PNG