topic Re: Dimention and Grouping in QlikView https://community.qlik.com/t5/QlikView/Dimention-and-Grouping/m-p/719887#M258559 <HTML><HEAD></HEAD><BODY><P>Maybe a calculated dimension with clusters about your EmployeeBucket is helpful for you:</P><P></P><P>Class(aggr(sum(distinct EmployeeBucket), Dimension1, Dimension2), $(ClusterSize), 'x', 0)</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 21 Aug 2014 12:57:19 GMT marcus_sommer 2014-08-21T12:57:19Z Dimention and Grouping https://community.qlik.com/t5/QlikView/Dimention-and-Grouping/m-p/719886#M258558 <HTML><HEAD></HEAD><BODY><P>HI All</P><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for the below expression </P><P></P><P>=if(sum( distinct EmployeeBucket )&gt;36 and sum(distinct EmployeeBucket )&lt;=70,Count( DISTINCT [Employee Number]))</P><P></P><P>I am using Employee band as expression but i want the sum(distinct employeebucket) to be calculated for each and every employee on that group separately</P><P></P><P></P><P>Please help</P></BODY></HTML> Thu, 21 Aug 2014 10:17:34 GMT https://community.qlik.com/t5/QlikView/Dimention-and-Grouping/m-p/719886#M258558 2014-08-21T10:17:34Z Re: Dimention and Grouping https://community.qlik.com/t5/QlikView/Dimention-and-Grouping/m-p/719887#M258559 <HTML><HEAD></HEAD><BODY><P>Maybe a calculated dimension with clusters about your EmployeeBucket is helpful for you:</P><P></P><P>Class(aggr(sum(distinct EmployeeBucket), Dimension1, Dimension2), $(ClusterSize), 'x', 0)</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 21 Aug 2014 12:57:19 GMT https://community.qlik.com/t5/QlikView/Dimention-and-Grouping/m-p/719887#M258559 marcus_sommer 2014-08-21T12:57:19Z