topic Re: Calculate AVG Head count in QlikView https://community.qlik.com/t5/QlikView/Calculate-AVG-Head-count/m-p/1063703#M355805 <HTML><HEAD></HEAD><BODY><P>chk dis</P><P><A href="https://community.qlik.com/qlik-blogpost/3208">Average – Which average?</A></P></BODY></HTML> Wed, 06 Apr 2016 09:17:43 GMT Chanty4u 2016-04-06T09:17:43Z Calculate AVG Head count https://community.qlik.com/t5/QlikView/Calculate-AVG-Head-count/m-p/1063699#M355801 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp;&nbsp; Hi All,</SPAN></P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">How to calculate AVG Head count for all Quarters.</SPAN></P><P><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt; mso-themecolor: text1; mso-style-textoutline-type: none; mso-style-textoutline-outlinestyle-dpiwidth: 0pt; mso-style-textoutline-outlinestyle-linecap: flat; mso-style-textoutline-outlinestyle-join: round; mso-style-textoutline-outlinestyle-pctmiterlimit: 0%; mso-style-textoutline-outlinestyle-dash: solid; mso-style-textoutline-outlinestyle-align: center; mso-style-textoutline-outlinestyle-compound: simple; mso-effects-shadow-color: black; mso-effects-shadow-themecolor: dark1; mso-effects-shadow-alpha: 40.0%; mso-effects-shadow-dpiradius: 3.0pt; mso-effects-shadow-dpidistance: 1.5pt; mso-effects-shadow-angledirection: 2700000; mso-effects-shadow-align: topleft; mso-effects-shadow-pctsx: 100.0%; mso-effects-shadow-pctsy: 100.0%; mso-effects-shadow-anglekx: 0; mso-effects-shadow-angleky: 0;">Actual Head count:</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt; mso-themecolor: text1; mso-style-textoutline-type: none; mso-style-textoutline-outlinestyle-dpiwidth: 0pt; mso-style-textoutline-outlinestyle-linecap: flat; mso-style-textoutline-outlinestyle-join: round; mso-style-textoutline-outlinestyle-pctmiterlimit: 0%; mso-style-textoutline-outlinestyle-dash: solid; mso-style-textoutline-outlinestyle-align: center; mso-style-textoutline-outlinestyle-compound: simple; mso-effects-shadow-color: black; mso-effects-shadow-themecolor: dark1; mso-effects-shadow-alpha: 40.0%; mso-effects-shadow-dpiradius: 3.0pt; mso-effects-shadow-dpidistance: 1.5pt; mso-effects-shadow-angledirection: 2700000; mso-effects-shadow-align: topleft; mso-effects-shadow-pctsx: 100.0%; mso-effects-shadow-pctsy: 100.0%; mso-effects-shadow-anglekx: 0; mso-effects-shadow-angleky: 0;">Q1 7256</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt; mso-themecolor: text1; mso-style-textoutline-type: none; mso-style-textoutline-outlinestyle-dpiwidth: 0pt; mso-style-textoutline-outlinestyle-linecap: flat; mso-style-textoutline-outlinestyle-join: round; mso-style-textoutline-outlinestyle-pctmiterlimit: 0%; mso-style-textoutline-outlinestyle-dash: solid; mso-style-textoutline-outlinestyle-align: center; mso-style-textoutline-outlinestyle-compound: simple; mso-effects-shadow-color: black; mso-effects-shadow-themecolor: dark1; mso-effects-shadow-alpha: 40.0%; mso-effects-shadow-dpiradius: 3.0pt; mso-effects-shadow-dpidistance: 1.5pt; mso-effects-shadow-angledirection: 2700000; mso-effects-shadow-align: topleft; mso-effects-shadow-pctsx: 100.0%; mso-effects-shadow-pctsy: 100.0%; mso-effects-shadow-anglekx: 0; mso-effects-shadow-angleky: 0;">Q2 7553</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt;">Q3 7599</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt;">Q4 7699</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt;">Average head count:</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt; mso-themecolor: text1; mso-style-textoutline-type: none; mso-style-textoutline-outlinestyle-dpiwidth: 0pt; mso-style-textoutline-outlinestyle-linecap: flat; mso-style-textoutline-outlinestyle-join: round; mso-style-textoutline-outlinestyle-pctmiterlimit: 0%; mso-style-textoutline-outlinestyle-dash: solid; mso-style-textoutline-outlinestyle-align: center; mso-style-textoutline-outlinestyle-compound: simple; mso-effects-shadow-color: black; mso-effects-shadow-themecolor: dark1; mso-effects-shadow-alpha: 40.0%; mso-effects-shadow-dpiradius: 3.0pt; mso-effects-shadow-dpidistance: 1.5pt; mso-effects-shadow-angledirection: 2700000; mso-effects-shadow-align: topleft; mso-effects-shadow-pctsx: 100.0%; mso-effects-shadow-pctsy: 100.0%; mso-effects-shadow-anglekx: 0; mso-effects-shadow-angleky: 0;">Q1 6807</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">EX: Q1=Apr,May,Jun</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P style="margin: 0px 0px 8pt;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">6681 +6759+6981=20421/3= 6807</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P></BODY></HTML> Wed, 06 Apr 2016 08:48:31 GMT https://community.qlik.com/t5/QlikView/Calculate-AVG-Head-count/m-p/1063699#M355801 Anonymous 2016-04-06T08:48:31Z Re: Calculate AVG Head count https://community.qlik.com/t5/QlikView/Calculate-AVG-Head-count/m-p/1063700#M355802 <HTML><HEAD></HEAD><BODY><P>Can you reload the application and reattach? The attached application doesn't seem to have Emp ID field in it</P></BODY></HTML> Wed, 06 Apr 2016 08:57:55 GMT https://community.qlik.com/t5/QlikView/Calculate-AVG-Head-count/m-p/1063700#M355802 sunny_talwar 2016-04-06T08:57:55Z Re: Calculate AVG Head count https://community.qlik.com/t5/QlikView/Calculate-AVG-Head-count/m-p/1063701#M355803 <HTML><HEAD></HEAD><BODY><P>Hi Sunny ,</P><P></P><P>I reattached.</P><P></P><P>Thanks,</P><P>Krishna</P></BODY></HTML> Wed, 06 Apr 2016 09:12:20 GMT https://community.qlik.com/t5/QlikView/Calculate-AVG-Head-count/m-p/1063701#M355803 Anonymous 2016-04-06T09:12:20Z Re: Calculate AVG Head count https://community.qlik.com/t5/QlikView/Calculate-AVG-Head-count/m-p/1063702#M355804 <HTML><HEAD></HEAD><BODY><P>Try this expression:</P><P><STRONG>=Avg(Aggr(Count(DISTINCT([Emp. Id])), Month))</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/120655_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Wed, 06 Apr 2016 09:16:04 GMT https://community.qlik.com/t5/QlikView/Calculate-AVG-Head-count/m-p/1063702#M355804 sunny_talwar 2016-04-06T09:16:04Z Re: Calculate AVG Head count https://community.qlik.com/t5/QlikView/Calculate-AVG-Head-count/m-p/1063703#M355805 <HTML><HEAD></HEAD><BODY><P>chk dis</P><P><A href="https://community.qlik.com/qlik-blogpost/3208">Average – Which average?</A></P></BODY></HTML> Wed, 06 Apr 2016 09:17:43 GMT https://community.qlik.com/t5/QlikView/Calculate-AVG-Head-count/m-p/1063703#M355805 Chanty4u 2016-04-06T09:17:43Z