topic Pareto in a table with groups in QlikView https://community.qlik.com/t5/QlikView/Pareto-in-a-table-with-groups/m-p/593002#M478363 <HTML><HEAD></HEAD><BODY><P>Hi, I am trying to build a table which will show me pareto groups and number of customers.</P><P>It should look something like this:</P><P></P><P><STRONG>Number Of Customers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Pareto Group</STRONG></P><TABLE border="1" class="jiveBorder" height="99" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" style="border: 1px solid #000000; width: 500px; height: 34px;" width="498"><TBODY><TR><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">&lt;50%</TD></TR><TR><TD style="padding: 2px;">13</TD><TD style="padding: 2px;">&lt;80%</TD></TR><TR><TD style="padding: 2px;">14</TD><TD style="padding: 2px;">&lt;90%</TD></TR><TR><TD style="padding: 2px;">14</TD><TD style="padding: 2px;">&lt;95%</TD></TR></TBODY></TABLE><P></P><P>Attached my model with the data and a Pareto table with all customers.</P><P></P><P>Any help will be appreciated</P><P></P><P>p.s: Note that this should be dynamic, meaning that It should be implemented in the UI level and not the Script level.</P><P></P><P>Thanks</P><P></P><P>Ori</P></BODY></HTML> Wed, 19 Mar 2014 08:56:26 GMT orital81 2014-03-19T08:56:26Z Pareto in a table with groups https://community.qlik.com/t5/QlikView/Pareto-in-a-table-with-groups/m-p/593002#M478363 <HTML><HEAD></HEAD><BODY><P>Hi, I am trying to build a table which will show me pareto groups and number of customers.</P><P>It should look something like this:</P><P></P><P><STRONG>Number Of Customers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Pareto Group</STRONG></P><TABLE border="1" class="jiveBorder" height="99" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" style="border: 1px solid #000000; width: 500px; height: 34px;" width="498"><TBODY><TR><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">&lt;50%</TD></TR><TR><TD style="padding: 2px;">13</TD><TD style="padding: 2px;">&lt;80%</TD></TR><TR><TD style="padding: 2px;">14</TD><TD style="padding: 2px;">&lt;90%</TD></TR><TR><TD style="padding: 2px;">14</TD><TD style="padding: 2px;">&lt;95%</TD></TR></TBODY></TABLE><P></P><P>Attached my model with the data and a Pareto table with all customers.</P><P></P><P>Any help will be appreciated</P><P></P><P>p.s: Note that this should be dynamic, meaning that It should be implemented in the UI level and not the Script level.</P><P></P><P>Thanks</P><P></P><P>Ori</P></BODY></HTML> Wed, 19 Mar 2014 08:56:26 GMT https://community.qlik.com/t5/QlikView/Pareto-in-a-table-with-groups/m-p/593002#M478363 orital81 2014-03-19T08:56:26Z Re: Pareto in a table with groups https://community.qlik.com/t5/QlikView/Pareto-in-a-table-with-groups/m-p/593003#M478364 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>There are two documents that could be useful:</P><P><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-6086">http://community.qlik.com/docs/DOC-6086</A></P><P><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-6088">http://community.qlik.com/docs/DOC-6088</A></P></BODY></HTML> Wed, 19 Mar 2014 10:11:06 GMT https://community.qlik.com/t5/QlikView/Pareto-in-a-table-with-groups/m-p/593003#M478364 whiteline 2014-03-19T10:11:06Z