topic Agregar Elemento Calculado / Add calculate Element as Excel HELP !! in QlikView https://community.qlik.com/t5/QlikView/Agregar-Elemento-Calculado-Add-calculate-Element-as-Excel-HELP/m-p/217200#M70445 <HTML><HEAD></HEAD><BODY><P>Hola, alguien me puede ayudar necesito agregar un elemento calculado como se hace en excel, lo que quiero es sumar la venta menos el costo para sacar el margen. /Hi, somebody helpme please i need add calculate element as excel, i want sum sales and cost (sorry for my english).</P><P>ejemplo/Ex.</P><TABLE border="0" cellpadding="0" cellspacing="0" width="232"><COL style="width: 98pt;" width="131" /><COL style="width: 76pt;" width="101" /><TBODY><TR height="17" style="height: 12.75pt;"><TD class="xl69" height="17" style="height: 12.75pt; width: 98pt;" width="131"><P>Original</P><P>Cta</P></TD><TD class="xl69" style="width: 76pt;" width="101">Real.</TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">010 - Venta Neta</TD><TD align="right" class="xl68">17,684,444</TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">020 - Costo de Venta</TD><TD align="right" class="xl68">-15,727,059</TD></TR></TBODY></TABLE><P>I Would like</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="232"><COL style="width: 98pt;" width="131" /><COL style="width: 76pt;" width="101" /><TBODY><TR height="17" style="height: 12.75pt;"><TD class="xl68" height="17" style="height: 12.75pt; width: 98pt;" width="131">Cta</TD><TD class="xl68" style="width: 76pt;" width="101">Real.</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl69" height="17" style="height: 12.75pt;">010 - Venta Neta</TD><TD class="xl70">17,684,444</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl69" height="17" style="height: 12.75pt;">020 - Costo de Venta</TD><TD class="xl70">-15,727,059</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl69" height="17" style="height: 12.75pt;">025 - Margen</TD><TD class="xl70">1,957,385</TD></TR></TBODY></TABLE><P></P></BODY></HTML> Fri, 15 Apr 2011 02:36:10 GMT 2011-04-15T02:36:10Z Agregar Elemento Calculado / Add calculate Element as Excel HELP !! https://community.qlik.com/t5/QlikView/Agregar-Elemento-Calculado-Add-calculate-Element-as-Excel-HELP/m-p/217200#M70445 <HTML><HEAD></HEAD><BODY><P>Hola, alguien me puede ayudar necesito agregar un elemento calculado como se hace en excel, lo que quiero es sumar la venta menos el costo para sacar el margen. /Hi, somebody helpme please i need add calculate element as excel, i want sum sales and cost (sorry for my english).</P><P>ejemplo/Ex.</P><TABLE border="0" cellpadding="0" cellspacing="0" width="232"><COL style="width: 98pt;" width="131" /><COL style="width: 76pt;" width="101" /><TBODY><TR height="17" style="height: 12.75pt;"><TD class="xl69" height="17" style="height: 12.75pt; width: 98pt;" width="131"><P>Original</P><P>Cta</P></TD><TD class="xl69" style="width: 76pt;" width="101">Real.</TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">010 - Venta Neta</TD><TD align="right" class="xl68">17,684,444</TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">020 - Costo de Venta</TD><TD align="right" class="xl68">-15,727,059</TD></TR></TBODY></TABLE><P>I Would like</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="232"><COL style="width: 98pt;" width="131" /><COL style="width: 76pt;" width="101" /><TBODY><TR height="17" style="height: 12.75pt;"><TD class="xl68" height="17" style="height: 12.75pt; width: 98pt;" width="131">Cta</TD><TD class="xl68" style="width: 76pt;" width="101">Real.</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl69" height="17" style="height: 12.75pt;">010 - Venta Neta</TD><TD class="xl70">17,684,444</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl69" height="17" style="height: 12.75pt;">020 - Costo de Venta</TD><TD class="xl70">-15,727,059</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl69" height="17" style="height: 12.75pt;">025 - Margen</TD><TD class="xl70">1,957,385</TD></TR></TBODY></TABLE><P></P></BODY></HTML> Fri, 15 Apr 2011 02:36:10 GMT https://community.qlik.com/t5/QlikView/Agregar-Elemento-Calculado-Add-calculate-Element-as-Excel-HELP/m-p/217200#M70445 2011-04-15T02:36:10Z