https://community.qlik.com/t5/QlikView/Top-N-calculation/m-p/1645640#M732264 <P>Do you have a sample app?</P><TABLE><TBODY><TR><TD>slab</TD><TD>No. of Custid</TD><TD>Orders</TD><TD>Price</TD></TR><TR><TD>Top 10% Customers</TD><TD>10000</TD><TD>10000</TD><TD>2000</TD></TR><TR><TD>Next 10% Customers</TD><TD>9000</TD><TD>12000</TD><TD>100</TD></TR><TR><TD>Next 20% Customers</TD><TD>16200</TD><TD>150000</TD><TD>30000</TD></TR><TR><TD>Next 30% Customers</TD><TD>19440</TD><TD>13000</TD><TD>200</TD></TR><TR><TD>Rest 30%</TD><TD>45360</TD><TD>13000</TD><TD>100</TD></TR></TBODY></TABLE><P>Why the third customer with 150k orders and buying the most expensive items is considered as next 20% of customers?</P> Tue, 12 Nov 2019 03:56:35 GMT Arthur_Fong 2019-11-12T03:56:35Z https://community.qlik.com/t5/QlikView/Top-N-calculation/m-p/1644875#M732263 <P>Dear experts..</P><P>I am looking to have a report create like below..</P><TABLE><TBODY><TR><TD>slab</TD><TD>No. of Custid</TD><TD>Orders</TD><TD>Price</TD></TR><TR><TD>Top 10% Customers</TD><TD>10000</TD><TD>10000</TD><TD>2000</TD></TR><TR><TD>Next 10% Customers</TD><TD>9000</TD><TD>12000</TD><TD>100</TD></TR><TR><TD>Next 20% Customers</TD><TD>16200</TD><TD>150000</TD><TD>30000</TD></TR><TR><TD>Next 30% Customers</TD><TD>19440</TD><TD>13000</TD><TD>200</TD></TR><TR><TD>Rest 30%</TD><TD>45360</TD><TD>13000</TD><TD>100</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>What is need is out of 1,00,000 customer, they are to be divided into various slabs like above.</P><P>Is this possible.?</P><P>Thank you!</P><P>Sean.</P><P>&nbsp;</P> Sat, 16 Nov 2024 19:42:43 GMT https://community.qlik.com/t5/QlikView/Top-N-calculation/m-p/1644875#M732263 Sean_BI 2024-11-16T19:42:43Z https://community.qlik.com/t5/QlikView/Top-N-calculation/m-p/1645640#M732264 <P>Do you have a sample app?</P><TABLE><TBODY><TR><TD>slab</TD><TD>No. of Custid</TD><TD>Orders</TD><TD>Price</TD></TR><TR><TD>Top 10% Customers</TD><TD>10000</TD><TD>10000</TD><TD>2000</TD></TR><TR><TD>Next 10% Customers</TD><TD>9000</TD><TD>12000</TD><TD>100</TD></TR><TR><TD>Next 20% Customers</TD><TD>16200</TD><TD>150000</TD><TD>30000</TD></TR><TR><TD>Next 30% Customers</TD><TD>19440</TD><TD>13000</TD><TD>200</TD></TR><TR><TD>Rest 30%</TD><TD>45360</TD><TD>13000</TD><TD>100</TD></TR></TBODY></TABLE><P>Why the third customer with 150k orders and buying the most expensive items is considered as next 20% of customers?</P> Tue, 12 Nov 2019 03:56:35 GMT https://community.qlik.com/t5/QlikView/Top-N-calculation/m-p/1645640#M732264 Arthur_Fong 2019-11-12T03:56:35Z https://community.qlik.com/t5/QlikView/Top-N-calculation/m-p/1646564#M732265 <P>Sean, the best I have are the following link that may be of some use for some ideas in addition to what Arthur posted.</P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis/ba-p/1468497" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis/ba-p/1468497</A></P> <P>Not sure if this will work or not, but figured I would toss it over for you to check out.</P> <P>Regards,<BR />Brett</P> Wed, 13 Nov 2019 16:43:42 GMT https://community.qlik.com/t5/QlikView/Top-N-calculation/m-p/1646564#M732265 Brett_Bleess 2019-11-13T16:43:42Z