topic Re: Percentage of first 15 elements in QlikView https://community.qlik.com/t5/QlikView/Percentage-of-first-15-elements/m-p/12232#M783191 <HTML><HEAD></HEAD><BODY><P>Your straight table is not correct. Can you share the data?</P></BODY></HTML> Mon, 12 Mar 2018 22:58:09 GMT isingh30 2018-03-12T22:58:09Z Percentage of first 15 elements https://community.qlik.com/t5/QlikView/Percentage-of-first-15-elements/m-p/12229#M783188 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I built a straight table , where I've shown the <SPAN style="text-decoration: underline;">first 3 items</SPAN> on a total of 10 items.</P><P></P><TABLE border="1" class="jiveBorder" jive-data-cell="{&quot;color&quot;:&quot;#000000&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&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: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px; width: 79px;" valign="middle"><STRONG>Client</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px; width: 92px;" valign="middle"><STRONG>Actual</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px; width: 93px;" valign="middle"><STRONG>Previous</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px; width: 118px;" valign="middle"><STRONG>% Act - Pvs</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">100%</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">15</TD><TD style="padding: 2px;">10<TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY></TBODY></TABLE></TD><TD style="padding: 2px;">50%</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">15</TD><TD style="padding: 2px;">33%</TD></TR><TR><TD style="padding: 2px;">Total</TD><TD style="padding: 2px;">45</TD><TD style="padding: 2px;">30</TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;">75%</SPAN></TD></TR></TBODY></TABLE><P></P><P>When I do the subtotal, the columns Actual and Previous give the right result, but the total percentage (the red value) is wrong!! (the total could be 50%).</P><P></P><P>Instead of doing the sum of partial values (3 items), it sums the total values (10 items).</P><P></P><P>I've also set the formula on : expression -&gt; mode of totalization (total expression)</P><P></P><P>Could anyone help me please?</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Percentage-of-first-15-elements/m-p/12229#M783188 Anonymous 2020-11-25T16:16:04Z Re: Percentage of first 15 elements https://community.qlik.com/t5/QlikView/Percentage-of-first-15-elements/m-p/12230#M783189 <HTML><HEAD></HEAD><BODY><P>Please share the app</P></BODY></HTML> Mon, 12 Mar 2018 17:52:19 GMT https://community.qlik.com/t5/QlikView/Percentage-of-first-15-elements/m-p/12230#M783189 shiveshsingh 2018-03-12T17:52:19Z Re: Percentage of first 15 elements https://community.qlik.com/t5/QlikView/Percentage-of-first-15-elements/m-p/12231#M783190 <HTML><HEAD></HEAD><BODY><P>Not sure how are you filtering your total 10-15 items to 3 items? Are you making selections in filter to reduce your straight table to 3 items?</P></BODY></HTML> Mon, 12 Mar 2018 18:27:50 GMT https://community.qlik.com/t5/QlikView/Percentage-of-first-15-elements/m-p/12231#M783190 Digvijay_Singh 2018-03-12T18:27:50Z Re: Percentage of first 15 elements https://community.qlik.com/t5/QlikView/Percentage-of-first-15-elements/m-p/12232#M783191 <HTML><HEAD></HEAD><BODY><P>Your straight table is not correct. Can you share the data?</P></BODY></HTML> Mon, 12 Mar 2018 22:58:09 GMT https://community.qlik.com/t5/QlikView/Percentage-of-first-15-elements/m-p/12232#M783191 isingh30 2018-03-12T22:58:09Z Re: Percentage of first 15 elements https://community.qlik.com/t5/QlikView/Percentage-of-first-15-elements/m-p/12233#M783192 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: 'trebuchet ms', geneva; font-size: 12px; background-color: #f2f2f2;">Hi,</SPAN></P><P><SPAN style="color: #000000; font-family: 'trebuchet ms', geneva; font-size: 12px; background-color: #f2f2f2;">Share the sample App</SPAN></P><P><SPAN style="color: #000000; font-family: 'trebuchet ms', geneva; font-size: 12px; background-color: #f2f2f2;"><BR /></SPAN></P><P><SPAN style="color: #000000; font-family: 'trebuchet ms', geneva; font-size: 12px; background-color: #f2f2f2;"><STRONG>Thanks &amp; regards,</STRONG></SPAN></P><P><SPAN style="color: #000000; font-family: 'trebuchet ms', geneva; font-size: 12px; background-color: #f2f2f2;"><STRONG>Venkata Sreekanth</STRONG><BR /></SPAN></P></BODY></HTML> Tue, 13 Mar 2018 09:34:52 GMT https://community.qlik.com/t5/QlikView/Percentage-of-first-15-elements/m-p/12233#M783192 Anonymous 2018-03-13T09:34:52Z Re: Percentage of first 15 elements https://community.qlik.com/t5/QlikView/Percentage-of-first-15-elements/m-p/12234#M783193 <HTML><HEAD></HEAD><BODY><P>3 Items were just an example. I filtered on 15 items.</P><P></P><P>The question is.....why the total percentage is on the total and not on the subtotal?</P><P></P><P><IMG alt="Filter.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/196293_Filter.jpg" style="height: 396px; width: 620px;" /></P></BODY></HTML> Wed, 14 Mar 2018 09:26:16 GMT https://community.qlik.com/t5/QlikView/Percentage-of-first-15-elements/m-p/12234#M783193 Anonymous 2018-03-14T09:26:16Z