topic Sumas Parciales in QlikView https://community.qlik.com/t5/QlikView/Sumas-Parciales/m-p/392015#M489958 <HTML><HEAD></HEAD><BODY><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN>Estoy calculado un porcentaje Sobre las Ventas, Pero solo para Ventas Mayores a un Monto X,</SPAN></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN>Por EJEMPLO SI Venta&gt; = 500000, SE APLICA un 2%, Sobre la ESA Venta.</SPAN></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN><BR /></SPAN></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN>El Problema es Que la Suma parcial, el cálculo del 2% lo aplica a la sumatoria total de de Ventas, y NO aVentas &gt; = 500000</SPAN></P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN>El Ejemplo En el Resultado deberia ser 290.503 y NO&nbsp; 300.877 </SPAN></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="background-color: #ffffff; border: 1px solid #cccccc; margin: 1px 0; padding: 3px; color: #737373; font-family: Arial;" width="440"><TBODY><TR style="border: 0px;"><TD class="xl24" height="17" style="border: 0px solid black; margin: 1px; padding: 3px;" width="177"><SPAN>Nombre del Cliente</SPAN></TD><TD class="xl25" style="border-top-color: black; border-right-color: black; border-bottom-color: black; border-style: solid solid solid none; margin: 1px; padding: 3px;" width="126"><SPAN>Venta Neta</SPAN></TD><TD class="xl25" style="border-top-color: black; border-right-color: black; border-bottom-color: black; border-style: solid solid solid none; margin: 1px; padding: 3px;" width="76"><SPAN>%</SPAN></TD></TR><TR style="border: 0px;"><TD class="xl25" height="17" style="border-right-color: black; border-bottom-color: black; border-left-color: black; border-style: none solid solid; margin: 1px; padding: 3px;"><BR /></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>817.098</SPAN></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>16.342</SPAN></TD></TR><TR style="border: 0px;"><TD class="xl25" height="17" style="border-right-color: black; border-bottom-color: black; border-left-color: black; border-style: none solid solid; margin: 1px; padding: 3px;"><BR /></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>1402755</SPAN></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>28.055</SPAN></TD></TR><TR style="border: 0px;"><TD class="xl25" height="17" style="border-right-color: black; border-bottom-color: black; border-left-color: black; border-style: none solid solid; margin: 1px; padding: 3px;"><BR /></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>390.435</SPAN></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>0</SPAN></TD></TR><TR style="border: 0px;"><TD class="xl25" height="17" style="border-right-color: black; border-bottom-color: black; border-left-color: black; border-style: none solid solid; margin: 1px; padding: 3px;"><BR /></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>2795627</SPAN></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>55.913</SPAN></TD></TR><TR style="border: 0px;"><TD class="xl25" height="17" style="border-right-color: black; border-bottom-color: black; border-left-color: black; border-style: none solid solid; margin: 1px; padding: 3px;"><BR /></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>1927428</SPAN></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>38.549</SPAN></TD></TR><TR style="border: 0px;"><TD class="xl25" height="17" style="border-right-color: black; border-bottom-color: black; border-left-color: black; border-style: none solid solid; margin: 1px; padding: 3px;"><BR /></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>869.914</SPAN></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>17.398</SPAN></TD></TR><TR style="border: 0px;"><TD class="xl25" height="17" style="border-right-color: black; border-bottom-color: black; border-left-color: black; border-style: none solid solid; margin: 1px; padding: 3px;"><BR /></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>128.254</SPAN></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>0</SPAN></TD></TR><TR style="border: 0px;"><TD class="xl25" height="17" style="border-right-color: black; border-bottom-color: black; border-left-color: black; border-style: none solid solid; margin: 1px; padding: 3px;"><BR /></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>711.049</SPAN></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>14.221</SPAN></TD></TR><TR style="border: 0px;"><TD class="xl25" height="17" style="border-right-color: black; border-bottom-color: black; border-left-color: black; border-style: none solid solid; margin: 1px; padding: 3px;"><BR /></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>2762674</SPAN></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>55.253</SPAN></TD></TR><TR style="border: 0px;"><TD class="xl25" height="17" style="border-right-color: black; border-bottom-color: black; border-left-color: black; border-style: none solid solid; margin: 1px; padding: 3px;"><BR /></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>600.345</SPAN></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>12.007</SPAN></TD></TR><TR style="border: 0px;"><TD class="xl25" height="17" style="border-right-color: black; border-bottom-color: black; border-left-color: black; border-style: none solid solid; margin: 1px; padding: 3px;"><BR /></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>1583619</SPAN></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>31.672</SPAN></TD></TR><TR style="border: 0px;"><TD class="xl25" height="18" style="border-right-color: black; border-bottom-color: black; border-left-color: black; border-style: none solid solid; margin: 1px; padding: 3px;"><BR /></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>1054644</SPAN></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>21.093</SPAN></TD><TD align="right" class="xl29" style="border: 0px solid black; margin: 1px; padding: 3px;"><SPAN>290.503</SPAN></TD></TR><TR style="border: 0px;"><TD class="xl27" height="18" style="border: 0px solid black; margin: 1px; padding: 3px;"><SPAN>Total</SPAN></TD><TD align="right" class="xl28" style="border: 0px solid black; margin: 1px; padding: 3px;"><SPAN>15043842</SPAN></TD><TD align="right" class="xl28" style="border-top-color: black; border-right-color: black; border-bottom-color: black; border-style: solid solid solid none; margin: 1px; padding: 3px;"><SPAN>300.877</SPAN></TD></TR></TBODY></TABLE><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN>Asi calculo ESE Porcentaje:</SPAN></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN>SI (sum (monto_ventas_neto)&gt; = 500000, suma (monto_ventas_neto) * (vPorcVentas/100), 0)</SPAN></P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN><SPAN>Espero puedan ayudame, Muchas Gracias.</SPAN></SPAN></P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN><SPAN>Olvide mencionar que el problema descrito arriba se da al usar una tabla PIVOTANTE, sin embargo en una tabla simple, el resultado es correcto</SPAN></SPAN></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="444"><TBODY><TR><TD class="xl22" height="17" width="131">Nombre del Cliente</TD><TD class="xl22" style="border-left: none;" width="139">Cantidad Venta Neta</TD><TD class="xl22" style="border-left: none;" width="121">Monto Venta Neta</TD><TD class="xl22" style="border-left: none;" width="53">%</TD></TR><TR><TD class="xl23" height="17" style="border-top: none;">aaaaaaaaaaaaaaaa</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">14</TD><TD align="right" class="xl25" style="border-top: none; border-left: none;">128,254</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl26" height="17" style="border-top: none;">bbbbbbbbbbbbbb</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">118</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">711,049</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">14,221</TD></TR><TR><TD class="xl23" height="17" style="border-top: none;">ccccccccccc</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">229</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">1,927,428</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">38,549</TD></TR><TR><TD class="xl26" height="17" style="border-top: none;">dddddddddddddd</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">87</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">817,098</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">16,342</TD></TR><TR><TD class="xl23" height="17" style="border-top: none;">eeeeeeeeeee</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">178</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">1,402,755</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">28,055</TD></TR><TR><TD class="xl26" height="17" style="border-top: none;">ffffffffffffffff</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">60</TD><TD align="right" class="xl28" style="border-top: none; border-left: none;">390,435</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl23" height="17" style="border-top: none;">gggggggggggggg</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">473</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">2,762,674</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">55,253</TD></TR><TR><TD class="xl26" height="17" style="border-top: none;">hhhhhhhhh</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">84</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">869,914</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">17,398</TD></TR><TR><TD class="xl23" height="17" style="border-top: none;">iiiiiiiiiiiii</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">286</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">2,795,627</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">55,913</TD></TR><TR><TD class="xl26" height="17" style="border-top: none;">jjjjjjjjjjjjjjjjjjj</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">199</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">1,583,619</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">31,672</TD></TR><TR><TD class="xl23" height="17" style="border-top: none;">kkkkkkkkkkkkkkkk</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">133</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">1,054,644</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">21,093</TD></TR><TR><TD class="xl26" height="17" style="border-top: none;">llllllllll</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">88</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">600,345</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">12,007</TD></TR><TR><TD class="xl29" height="17">Totales</TD><TD align="right" class="xl30">1,950</TD><TD align="right" class="xl30" style="border-left: none;">15,043,842</TD><TD align="right" class="xl30" style="border-left: none;">290,503</TD></TR></TBODY></TABLE><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN><SPAN><BR /></SPAN></SPAN></P></BODY></HTML> Thu, 01 Nov 2012 14:14:12 GMT 2012-11-01T14:14:12Z Sumas Parciales https://community.qlik.com/t5/QlikView/Sumas-Parciales/m-p/392015#M489958 <HTML><HEAD></HEAD><BODY><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN>Estoy calculado un porcentaje Sobre las Ventas, Pero solo para Ventas Mayores a un Monto X,</SPAN></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN>Por EJEMPLO SI Venta&gt; = 500000, SE APLICA un 2%, Sobre la ESA Venta.</SPAN></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN><BR /></SPAN></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN>El Problema es Que la Suma parcial, el cálculo del 2% lo aplica a la sumatoria total de de Ventas, y NO aVentas &gt; = 500000</SPAN></P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN>El Ejemplo En el Resultado deberia ser 290.503 y NO&nbsp; 300.877 </SPAN></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="background-color: #ffffff; border: 1px solid #cccccc; margin: 1px 0; padding: 3px; color: #737373; font-family: Arial;" width="440"><TBODY><TR style="border: 0px;"><TD class="xl24" height="17" style="border: 0px solid black; margin: 1px; padding: 3px;" width="177"><SPAN>Nombre del Cliente</SPAN></TD><TD class="xl25" style="border-top-color: black; border-right-color: black; border-bottom-color: black; border-style: solid solid solid none; margin: 1px; padding: 3px;" width="126"><SPAN>Venta Neta</SPAN></TD><TD class="xl25" style="border-top-color: black; border-right-color: black; border-bottom-color: black; border-style: solid solid solid none; margin: 1px; padding: 3px;" width="76"><SPAN>%</SPAN></TD></TR><TR style="border: 0px;"><TD class="xl25" height="17" style="border-right-color: black; border-bottom-color: black; border-left-color: black; border-style: none solid solid; margin: 1px; padding: 3px;"><BR /></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>817.098</SPAN></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>16.342</SPAN></TD></TR><TR style="border: 0px;"><TD class="xl25" height="17" style="border-right-color: black; border-bottom-color: black; border-left-color: black; border-style: none solid solid; margin: 1px; padding: 3px;"><BR /></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>1402755</SPAN></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>28.055</SPAN></TD></TR><TR style="border: 0px;"><TD class="xl25" height="17" style="border-right-color: black; border-bottom-color: black; border-left-color: black; border-style: none solid solid; margin: 1px; padding: 3px;"><BR /></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>390.435</SPAN></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>0</SPAN></TD></TR><TR style="border: 0px;"><TD class="xl25" height="17" style="border-right-color: black; border-bottom-color: black; border-left-color: black; border-style: none solid solid; margin: 1px; padding: 3px;"><BR /></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>2795627</SPAN></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>55.913</SPAN></TD></TR><TR style="border: 0px;"><TD class="xl25" height="17" style="border-right-color: black; border-bottom-color: black; border-left-color: black; border-style: none solid solid; margin: 1px; padding: 3px;"><BR /></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>1927428</SPAN></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>38.549</SPAN></TD></TR><TR style="border: 0px;"><TD class="xl25" height="17" style="border-right-color: black; border-bottom-color: black; border-left-color: black; border-style: none solid solid; margin: 1px; padding: 3px;"><BR /></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>869.914</SPAN></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>17.398</SPAN></TD></TR><TR style="border: 0px;"><TD class="xl25" height="17" style="border-right-color: black; border-bottom-color: black; border-left-color: black; border-style: none solid solid; margin: 1px; padding: 3px;"><BR /></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>128.254</SPAN></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>0</SPAN></TD></TR><TR style="border: 0px;"><TD class="xl25" height="17" style="border-right-color: black; border-bottom-color: black; border-left-color: black; border-style: none solid solid; margin: 1px; padding: 3px;"><BR /></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>711.049</SPAN></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>14.221</SPAN></TD></TR><TR style="border: 0px;"><TD class="xl25" height="17" style="border-right-color: black; border-bottom-color: black; border-left-color: black; border-style: none solid solid; margin: 1px; padding: 3px;"><BR /></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>2762674</SPAN></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>55.253</SPAN></TD></TR><TR style="border: 0px;"><TD class="xl25" height="17" style="border-right-color: black; border-bottom-color: black; border-left-color: black; border-style: none solid solid; margin: 1px; padding: 3px;"><BR /></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>600.345</SPAN></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>12.007</SPAN></TD></TR><TR style="border: 0px;"><TD class="xl25" height="17" style="border-right-color: black; border-bottom-color: black; border-left-color: black; border-style: none solid solid; margin: 1px; padding: 3px;"><BR /></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>1583619</SPAN></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>31.672</SPAN></TD></TR><TR style="border: 0px;"><TD class="xl25" height="18" style="border-right-color: black; border-bottom-color: black; border-left-color: black; border-style: none solid solid; margin: 1px; padding: 3px;"><BR /></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>1054644</SPAN></TD><TD align="right" class="xl26" style="border-right-color: black; border-bottom-color: black; border-style: none solid solid none; margin: 1px; padding: 3px;"><SPAN>21.093</SPAN></TD><TD align="right" class="xl29" style="border: 0px solid black; margin: 1px; padding: 3px;"><SPAN>290.503</SPAN></TD></TR><TR style="border: 0px;"><TD class="xl27" height="18" style="border: 0px solid black; margin: 1px; padding: 3px;"><SPAN>Total</SPAN></TD><TD align="right" class="xl28" style="border: 0px solid black; margin: 1px; padding: 3px;"><SPAN>15043842</SPAN></TD><TD align="right" class="xl28" style="border-top-color: black; border-right-color: black; border-bottom-color: black; border-style: solid solid solid none; margin: 1px; padding: 3px;"><SPAN>300.877</SPAN></TD></TR></TBODY></TABLE><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN>Asi calculo ESE Porcentaje:</SPAN></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN>SI (sum (monto_ventas_neto)&gt; = 500000, suma (monto_ventas_neto) * (vPorcVentas/100), 0)</SPAN></P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN><SPAN>Espero puedan ayudame, Muchas Gracias.</SPAN></SPAN></P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN><SPAN>Olvide mencionar que el problema descrito arriba se da al usar una tabla PIVOTANTE, sin embargo en una tabla simple, el resultado es correcto</SPAN></SPAN></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="444"><TBODY><TR><TD class="xl22" height="17" width="131">Nombre del Cliente</TD><TD class="xl22" style="border-left: none;" width="139">Cantidad Venta Neta</TD><TD class="xl22" style="border-left: none;" width="121">Monto Venta Neta</TD><TD class="xl22" style="border-left: none;" width="53">%</TD></TR><TR><TD class="xl23" height="17" style="border-top: none;">aaaaaaaaaaaaaaaa</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">14</TD><TD align="right" class="xl25" style="border-top: none; border-left: none;">128,254</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl26" height="17" style="border-top: none;">bbbbbbbbbbbbbb</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">118</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">711,049</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">14,221</TD></TR><TR><TD class="xl23" height="17" style="border-top: none;">ccccccccccc</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">229</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">1,927,428</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">38,549</TD></TR><TR><TD class="xl26" height="17" style="border-top: none;">dddddddddddddd</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">87</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">817,098</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">16,342</TD></TR><TR><TD class="xl23" height="17" style="border-top: none;">eeeeeeeeeee</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">178</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">1,402,755</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">28,055</TD></TR><TR><TD class="xl26" height="17" style="border-top: none;">ffffffffffffffff</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">60</TD><TD align="right" class="xl28" style="border-top: none; border-left: none;">390,435</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl23" height="17" style="border-top: none;">gggggggggggggg</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">473</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">2,762,674</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">55,253</TD></TR><TR><TD class="xl26" height="17" style="border-top: none;">hhhhhhhhh</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">84</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">869,914</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">17,398</TD></TR><TR><TD class="xl23" height="17" style="border-top: none;">iiiiiiiiiiiii</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">286</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">2,795,627</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">55,913</TD></TR><TR><TD class="xl26" height="17" style="border-top: none;">jjjjjjjjjjjjjjjjjjj</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">199</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">1,583,619</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">31,672</TD></TR><TR><TD class="xl23" height="17" style="border-top: none;">kkkkkkkkkkkkkkkk</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">133</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">1,054,644</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">21,093</TD></TR><TR><TD class="xl26" height="17" style="border-top: none;">llllllllll</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">88</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">600,345</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">12,007</TD></TR><TR><TD class="xl29" height="17">Totales</TD><TD align="right" class="xl30">1,950</TD><TD align="right" class="xl30" style="border-left: none;">15,043,842</TD><TD align="right" class="xl30" style="border-left: none;">290,503</TD></TR></TBODY></TABLE><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN><SPAN><BR /></SPAN></SPAN></P></BODY></HTML> Thu, 01 Nov 2012 14:14:12 GMT https://community.qlik.com/t5/QlikView/Sumas-Parciales/m-p/392015#M489958 2012-11-01T14:14:12Z