topic 80/20 without Pareto in QlikView https://community.qlik.com/t5/QlikView/80-20-without-Pareto/m-p/439311#M557756 <HTML><HEAD></HEAD><BODY><P>is it possible to do a Count(Customers) from Total Customers in a cycle group that make up 80% of the sales for each of the value's in the group?</P><P></P><P>For instance,</P><P></P><P>1. cycle group for Region, Office, Employee</P><P>2. get a count of customers depending on the current field</P><P>3. get a count of customers depending on the current field that make up 80% of the sales, for eg. Region - NorthAmerica has 5 offices and 20 employees. We want to know how many customers in Region - North America, Region - Europe make up 80% of sales, then user can change cycle and expression should be able to compute the count of customer for each value in the next grouping.</P><P></P><P>This is not Dimension Limits because it is not 80% based on the values displayed for the current field, but rather dimension limits for each field value of the current field</P></BODY></HTML> Wed, 05 Jun 2013 01:54:45 GMT avastani 2013-06-05T01:54:45Z 80/20 without Pareto https://community.qlik.com/t5/QlikView/80-20-without-Pareto/m-p/439311#M557756 <HTML><HEAD></HEAD><BODY><P>is it possible to do a Count(Customers) from Total Customers in a cycle group that make up 80% of the sales for each of the value's in the group?</P><P></P><P>For instance,</P><P></P><P>1. cycle group for Region, Office, Employee</P><P>2. get a count of customers depending on the current field</P><P>3. get a count of customers depending on the current field that make up 80% of the sales, for eg. Region - NorthAmerica has 5 offices and 20 employees. We want to know how many customers in Region - North America, Region - Europe make up 80% of sales, then user can change cycle and expression should be able to compute the count of customer for each value in the next grouping.</P><P></P><P>This is not Dimension Limits because it is not 80% based on the values displayed for the current field, but rather dimension limits for each field value of the current field</P></BODY></HTML> Wed, 05 Jun 2013 01:54:45 GMT https://community.qlik.com/t5/QlikView/80-20-without-Pareto/m-p/439311#M557756 avastani 2013-06-05T01:54:45Z