Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
avastani
Partner - Creator III
Partner - Creator III

80/20 without Pareto

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?

For instance,

1. cycle group for Region, Office, Employee

2. get a count of customers depending on the current field

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.

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

0 Replies