topic Re: Issue in expression with aggr in QlikView https://community.qlik.com/t5/QlikView/Issue-in-expression-with-aggr/m-p/122490#M18708 <HTML><HEAD></HEAD><BODY><P>Hello Sunny</P><P></P><P>I have attached the screenshot. </P><P></P><P>Eg: for Europe there are 11 staff.. </P><P></P><P>I need last column as&nbsp; second last column / 11. </P><P></P><P>ie: 0.85/11 = 0.07.....</P><P></P><P>Dimensons are , Type (not visible in screenshot) , Destination , Staff Name. </P><P>Remaining are measures. </P></BODY></HTML> Mon, 09 Jul 2018 12:30:38 GMT Anonymous 2018-07-09T12:30:38Z Issue in expression with aggr https://community.qlik.com/t5/QlikView/Issue-in-expression-with-aggr/m-p/122487#M18705 <HTML><HEAD></HEAD><BODY><P>Hello Friends</P><P></P><P>I am using below expression in a Pivot chart , which divides Sale Amount by Count of staff to get Sale per staff.</P><P>However the entire total amount displays for each of the staff. Am I doing some mistake?</P><P></P><P>Kindly help.</P><P></P><P>[Sum(SALE_AMT)]&nbsp;&nbsp; / aggr(count(Staff),BU,DESTINATION)</P><P></P><P></P><P></P><P>Thanks &amp; Regards</P><P>Chintan Gala</P></BODY></HTML> Mon, 09 Jul 2018 12:06:06 GMT https://community.qlik.com/t5/QlikView/Issue-in-expression-with-aggr/m-p/122487#M18705 Anonymous 2018-07-09T12:06:06Z Re: Issue in expression with aggr https://community.qlik.com/t5/QlikView/Issue-in-expression-with-aggr/m-p/122488#M18706 <HTML><HEAD></HEAD><BODY><P>BU, DESTINATION and Staff are the dimensions...used in the&nbsp;&nbsp; pivot chart..</P></BODY></HTML> Mon, 09 Jul 2018 12:17:36 GMT https://community.qlik.com/t5/QlikView/Issue-in-expression-with-aggr/m-p/122488#M18706 Anonymous 2018-07-09T12:17:36Z Re: Issue in expression with aggr https://community.qlik.com/t5/QlikView/Issue-in-expression-with-aggr/m-p/122489#M18707 <HTML><HEAD></HEAD><BODY><P>Would you be able to share an image of what you are seeing and explain what you would want to see?</P></BODY></HTML> Mon, 09 Jul 2018 12:18:03 GMT https://community.qlik.com/t5/QlikView/Issue-in-expression-with-aggr/m-p/122489#M18707 sunny_talwar 2018-07-09T12:18:03Z Re: Issue in expression with aggr https://community.qlik.com/t5/QlikView/Issue-in-expression-with-aggr/m-p/122490#M18708 <HTML><HEAD></HEAD><BODY><P>Hello Sunny</P><P></P><P>I have attached the screenshot. </P><P></P><P>Eg: for Europe there are 11 staff.. </P><P></P><P>I need last column as&nbsp; second last column / 11. </P><P></P><P>ie: 0.85/11 = 0.07.....</P><P></P><P>Dimensons are , Type (not visible in screenshot) , Destination , Staff Name. </P><P>Remaining are measures. </P></BODY></HTML> Mon, 09 Jul 2018 12:30:38 GMT https://community.qlik.com/t5/QlikView/Issue-in-expression-with-aggr/m-p/122490#M18708 Anonymous 2018-07-09T12:30:38Z