topic Re: average in QlikView

average

Thu, 08 Aug 2013 09:55:31 GMT

I want to calculate the average of formula below but doesn't succeed.

=round(round(((count({$<HR_Calendar.Year = ,HR_Calendar.MonthName = , IsNuInDienst = {'indienst'}>} Empl.NAME)-

if(count({$<HR_Calendar.Year = ,HR_Calendar.MonthName = , IsNuInDienst = {'indienst'}>} Empl.NAME)>0,1,0))),0.01)/12

,0.01)

Re: average

Gysbert_Wassenaar — Thu, 08 Aug 2013 10:04:37 GMT

If you want an average of counts you need to use the aggr function.

avg(aggr(

round(rangemax(0,count({$<HR_Calendar.Year = ,HR_Calendar.MonthName = , IsNuInDienst = {'indienst'}>} Empl.NAME)-1)/12,0.01)

, Dim1, Dim2, ... DimN)

Replace Dim1, Dim2, ... DimN with the dimensions over which you want to aggregate the average.

Re: average

Thu, 08 Aug 2013 10:14:04 GMT

I assume you are dutch

De bedoeling is om de gemiddelde functieverblijftijd van medewekers te berekenen. Deze functieverblijftijd wordt gebaseerd op het aantal maanden dat mwd op een bep functie staat. Kan je de formule in zijn geheel aanpassen, want krijg foutmelding.

Alvast bedankt !!

=round(round(((count({$<HR_Calendar.Year = ,HR_Calendar.MonthName = , IsNuInDienst = {'indienst'}>} Medewerker.NAAMLANG)-

if(count({$<HR_Calendar.Year = ,HR_Calendar.MonthName = , IsNuInDienst = {'indienst'}>} Medewerker.NAAMLANG)>0,1,0))),0.01)/12

,0.01)