topic x% of total in sorted values in QlikView https://community.qlik.com/t5/QlikView/x-of-total-in-sorted-values/m-p/71501#M458084 <HTML><HEAD></HEAD><BODY><P>I need to calculate the x% items. </P><P></P><P>for instance:</P><TABLE border="1" class="jiveBorder" height="174" style="border: 1px solid rgb(0, 0, 0); width: 226px; height: 102px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Item</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Quantiy</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">4</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">6</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">8</TD></TR><TR><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">10</TD></TR><TR><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">12</TD></TR></TBODY></TABLE><P></P><P>ordered by quantity and then the items that lead to 25% of the total</P><P></P><TABLE border="1" class="jiveBorder" height="174" style="border: 1px solid rgb(0, 0, 0); width: 219px; height: 139px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>item</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>quantity</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>cumulative</STRONG></TH></TR><TR><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">12</TD><TD style="padding: 2px;">12</TD></TR><TR><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">22</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">8</TD><TD style="padding: 2px;">30</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">etc.</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">4</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">42</TD></TR></TBODY></TABLE><P></P><P>25% of total = 10,5 so my result should be: item 6</P><TABLE border="1" class="jiveBorder" height="49" style="border: 1px solid rgb(0, 0, 0); width: 217px; height: 46px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">item</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">quantity</TH></TR><TR><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">12</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 22 May 2018 10:42:06 GMT Michiel_QV_Fan 2018-05-22T10:42:06Z x% of total in sorted values https://community.qlik.com/t5/QlikView/x-of-total-in-sorted-values/m-p/71501#M458084 <HTML><HEAD></HEAD><BODY><P>I need to calculate the x% items. </P><P></P><P>for instance:</P><TABLE border="1" class="jiveBorder" height="174" style="border: 1px solid rgb(0, 0, 0); width: 226px; height: 102px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Item</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Quantiy</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">4</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">6</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">8</TD></TR><TR><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">10</TD></TR><TR><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">12</TD></TR></TBODY></TABLE><P></P><P>ordered by quantity and then the items that lead to 25% of the total</P><P></P><TABLE border="1" class="jiveBorder" height="174" style="border: 1px solid rgb(0, 0, 0); width: 219px; height: 139px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>item</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>quantity</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>cumulative</STRONG></TH></TR><TR><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">12</TD><TD style="padding: 2px;">12</TD></TR><TR><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">22</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">8</TD><TD style="padding: 2px;">30</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">etc.</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">4</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">42</TD></TR></TBODY></TABLE><P></P><P>25% of total = 10,5 so my result should be: item 6</P><TABLE border="1" class="jiveBorder" height="49" style="border: 1px solid rgb(0, 0, 0); width: 217px; height: 46px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">item</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">quantity</TH></TR><TR><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">12</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 22 May 2018 10:42:06 GMT https://community.qlik.com/t5/QlikView/x-of-total-in-sorted-values/m-p/71501#M458084 Michiel_QV_Fan 2018-05-22T10:42:06Z Re: x% of total in sorted values https://community.qlik.com/t5/QlikView/x-of-total-in-sorted-values/m-p/71502#M458085 <HTML><HEAD></HEAD><BODY><P>Look here</P><P><A href="https://community.qlik.com/thread/302225">x% of total in sorted values</A></P></BODY></HTML> Tue, 22 May 2018 11:24:26 GMT https://community.qlik.com/t5/QlikView/x-of-total-in-sorted-values/m-p/71502#M458085 sunny_talwar 2018-05-22T11:24:26Z Re: x% of total in sorted values https://community.qlik.com/t5/QlikView/x-of-total-in-sorted-values/m-p/71503#M458086 <HTML><HEAD></HEAD><BODY><P>browser issues, this happend before. Strange. Removed the duplicate entry</P></BODY></HTML> Tue, 22 May 2018 11:28:51 GMT https://community.qlik.com/t5/QlikView/x-of-total-in-sorted-values/m-p/71503#M458086 Michiel_QV_Fan 2018-05-22T11:28:51Z Re: x% of total in sorted values https://community.qlik.com/t5/QlikView/x-of-total-in-sorted-values/m-p/71504#M458087 <HTML><HEAD></HEAD><BODY><P>Are you looking to do this in the script or front end?</P></BODY></HTML> Tue, 22 May 2018 11:33:38 GMT https://community.qlik.com/t5/QlikView/x-of-total-in-sorted-values/m-p/71504#M458087 sunny_talwar 2018-05-22T11:33:38Z Re: x% of total in sorted values https://community.qlik.com/t5/QlikView/x-of-total-in-sorted-values/m-p/71505#M458088 <HTML><HEAD></HEAD><BODY><P>Front end because it is dependent on the selections made.</P></BODY></HTML> Wed, 23 May 2018 11:28:18 GMT https://community.qlik.com/t5/QlikView/x-of-total-in-sorted-values/m-p/71505#M458088 Michiel_QV_Fan 2018-05-23T11:28:18Z Re: x% of total in sorted values https://community.qlik.com/t5/QlikView/x-of-total-in-sorted-values/m-p/71506#M458089 <HTML><HEAD></HEAD><BODY><P>You would need something like this</P><P><A href="https://community.qlik.com/qlik-blogpost/5065">Recipe for a Pareto Analysis – Revisited</A></P></BODY></HTML> Wed, 23 May 2018 11:33:52 GMT https://community.qlik.com/t5/QlikView/x-of-total-in-sorted-values/m-p/71506#M458089 sunny_talwar 2018-05-23T11:33:52Z