topic Re: Totales en QlikView in QlikView https://community.qlik.com/t5/QlikView/Totales-en-QlikView/m-p/842908#M993282 <HTML><HEAD></HEAD><BODY><P>Iassume you want to do cross table. I have attached qvd and sample data. You can see the code in script editor. Please have a look.</P></BODY></HTML> Thu, 09 Jul 2015 16:59:53 GMT Anonymous 2015-07-09T16:59:53Z Totales en QlikView https://community.qlik.com/t5/QlikView/Totales-en-QlikView/m-p/842907#M993281 <HTML><HEAD></HEAD><BODY><P>Hello, I have a problem, when I load sales totals me the negative values appear in a line distianta to positive values.</P><P></P><P></P><P>calculating the value of sales in this way:</P><P>I realize that a month</P><P></P><P>example of how the data sample</P><P> Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333330154419px;">Family&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>January&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; February&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; March</P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&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;}" style="width: 996px;"><TBODY><TR><TD class="xl63" height="17" width="185">FOOD </TD><TD class="xl64" style="border-left: none;" width="98">DOYPACK</TD><TD class="xl65" width="27"> </TD><TD class="xl66" style="border-left: none;" width="98"> </TD><TD class="xl66" style="border-left: none;" width="98"> </TD><TD align="right" class="xl67" style="border-left: none;" width="98">20.880</TD><TD align="right" class="xl67" style="border-left: none;" width="98">21.423</TD><TD class="xl66" style="border-left: none;" width="98"> </TD><TD class="xl66" style="border-left: none;" width="98"> </TD><TD align="right" class="xl68" style="border-left: none;" width="98">42.303</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">FOOD </TD><TD class="xl64" style="border-top: none; border-left: none;"> </TD><TD class="xl65" style="border-top: none;"> </TD><TD class="xl66" style="border-top: none; border-left: none;"> </TD><TD class="xl66" style="border-top: none; border-left: none;"> </TD><TD class="xl66" style="border-top: none; border-left: none;"> </TD><TD class="xl66" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">-21.212</TD><TD class="xl66" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">-21.212</TD></TR></TBODY></TABLE><P></P><P>And I need this one is a line to add up your total.</P><P></P><P></P><P></P><P></P><P>Thank You So Much</P><P>Nelson.</P></BODY></HTML> Thu, 09 Jul 2015 16:32:38 GMT https://community.qlik.com/t5/QlikView/Totales-en-QlikView/m-p/842907#M993281 2015-07-09T16:32:38Z Re: Totales en QlikView https://community.qlik.com/t5/QlikView/Totales-en-QlikView/m-p/842908#M993282 <HTML><HEAD></HEAD><BODY><P>Iassume you want to do cross table. I have attached qvd and sample data. You can see the code in script editor. Please have a look.</P></BODY></HTML> Thu, 09 Jul 2015 16:59:53 GMT https://community.qlik.com/t5/QlikView/Totales-en-QlikView/m-p/842908#M993282 Anonymous 2015-07-09T16:59:53Z Re: Totales en QlikView https://community.qlik.com/t5/QlikView/Totales-en-QlikView/m-p/842909#M993283 <HTML><HEAD></HEAD><BODY><P>Luis , podras explicar un poco mejor cual es tu problema, para que sea mas facil ayudarte?</P><P></P><P>podras subir el archivo o poner una imagen?</P><P></P><P>muchas gracias</P></BODY></HTML> Thu, 09 Jul 2015 18:50:23 GMT https://community.qlik.com/t5/QlikView/Totales-en-QlikView/m-p/842909#M993283 fkeuroglian 2015-07-09T18:50:23Z Re: Totales en QlikView https://community.qlik.com/t5/QlikView/Totales-en-QlikView/m-p/842910#M993284 <HTML><HEAD></HEAD><BODY><P>Muchas Gracias por responder, pero ya encontre el problema. cuando realizan una nota de&nbsp; credito cambian el nombre de artitulo que era mi llave y por lo tanto no lograba encontrarlo.</P><P></P><P></P><P>Gracias!</P></BODY></HTML> Thu, 09 Jul 2015 19:30:39 GMT https://community.qlik.com/t5/QlikView/Totales-en-QlikView/m-p/842910#M993284 2015-07-09T19:30:39Z Re: Totales en QlikView https://community.qlik.com/t5/QlikView/Totales-en-QlikView/m-p/842911#M993285 <HTML><HEAD></HEAD><BODY><P>Amigo could you please attach your files. I would be glad to help you then. Gracias!</P></BODY></HTML> Thu, 09 Jul 2015 19:45:09 GMT https://community.qlik.com/t5/QlikView/Totales-en-QlikView/m-p/842911#M993285 Anonymous 2015-07-09T19:45:09Z