topic Re: Pareto expression in QlikView https://community.qlik.com/t5/QlikView/Pareto-expression/m-p/414007#M154020 <HTML><HEAD></HEAD><BODY><P>See <A _jive_internal="true" href="https://community.qlik.com/thread/1668">here</A></P></BODY></HTML> Tue, 30 Apr 2013 13:40:28 GMT Gysbert_Wassenaar 2013-04-30T13:40:28Z Pareto expression https://community.qlik.com/t5/QlikView/Pareto-expression/m-p/414006#M154019 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'm looking for a way to build a kind of Pareto not as a chart but as an expression</P><P></P><P>The data I have look like</P><P>PRODUCT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SALES</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30</P><P>D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40</P><P>E&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 60</P><P></P><P></P><P>What i'm looking for is count(product) = 80% of the sales</P><P></P><P>I konw how to do that with a chart but in an expression...</P><P></P><P>Any idea?</P></BODY></HTML> Tue, 30 Apr 2013 13:39:07 GMT https://community.qlik.com/t5/QlikView/Pareto-expression/m-p/414006#M154019 2013-04-30T13:39:07Z Re: Pareto expression https://community.qlik.com/t5/QlikView/Pareto-expression/m-p/414007#M154020 <HTML><HEAD></HEAD><BODY><P>See <A _jive_internal="true" href="https://community.qlik.com/thread/1668">here</A></P></BODY></HTML> Tue, 30 Apr 2013 13:40:28 GMT https://community.qlik.com/t5/QlikView/Pareto-expression/m-p/414007#M154020 Gysbert_Wassenaar 2013-04-30T13:40:28Z Re: Pareto expression https://community.qlik.com/t5/QlikView/Pareto-expression/m-p/414008#M154021 <HTML><HEAD></HEAD><BODY><P>Many thanks Gysbert I was having a look</P><P></P><P>As I understood it requires the sales to be ordered</P></BODY></HTML> Tue, 30 Apr 2013 13:45:46 GMT https://community.qlik.com/t5/QlikView/Pareto-expression/m-p/414008#M154021 2013-04-30T13:45:46Z