topic Consulta : Corte de Control in QlikView https://community.qlik.com/t5/QlikView/Consulta-Corte-de-Control/m-p/206865#M62816 <HTML><HEAD></HEAD><BODY><P></P><P>Quisiera que el ultimo campo, al cual yo llamo Saldo, se vaya calculando por cada registro</P><P></P><P></P><BR /><BR /> <P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width:539pt;border-collapse:collapse;" width="718"><COLGROUP><COL span="3" style="width:60pt;" width="80" /><COL style="width:119pt;mso-width-source:userset;mso-width-alt:5778;" width="158" /><COL span="4" style="width:60pt;" width="80" /></COLGROUP><TBODY><TR style="height:12.75pt;"><TD height="17" style="width:60pt;height:12.75pt;background-color:transparent;border:#d4d0c8;" width="80">Credito</TD><TD style="width:60pt;background-color:transparent;border:#d4d0c8;" width="80">Importe</TD><TD style="width:60pt;background-color:transparent;border:#d4d0c8;" width="80">Cuota</TD><TD style="width:119pt;background-color:transparent;border:#d4d0c8;" width="158">Importe a restar del saldo</TD><TD style="width:60pt;background-color:transparent;border:#d4d0c8;" width="80">Saldo</TD><TD style="width:60pt;background-color:transparent;border:#d4d0c8;" width="80"></TD><TD style="width:60pt;background-color:transparent;border:#d4d0c8;" width="80"></TD><TD style="width:60pt;background-color:transparent;border:#d4d0c8;" width="80"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">27,02</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD colspan="2" style="background-color:transparent;mso-ignore:colspan;border:#d4d0c8;">Ej: 2474,23-27,02 = 2447,21</TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">60,26</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2447,21</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">3</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">63,17</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2386,95</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">4</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">66,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2323,78</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">5</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">69,43</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2257,55</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">6</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">72,79</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2188,12</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">7</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">76,32</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2115,33</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">8</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">80,01</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2039,01</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">9</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">83,88</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">1959</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">10</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">87,94</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">1875,12</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">11</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">92,2</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">1787,18</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">12</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">96,66</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">1694,98</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">13</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">101,35</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">1598,32</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">14</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">106,26</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">1496,97</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">15</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">111,4</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">1390,71</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">16</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">116,79</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">1279,31</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">17</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">122,44</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">1162,52</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">18</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">128,37</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">1040,08</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">19</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">134,57</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">911,71</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">20</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">141,1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">777,14</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">21</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">147,92</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">636,04</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">22</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">155,07</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">488,12</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">162,59</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">333,05</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">24</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">170,46</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">170,46</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P><I>PRO000_temp2:</I></P><P style="font-weight: bold"></P><P style="font-weight: bold">noconcatenate</P><B></B><P style="font-weight: bold">LOAD</P><BR /><BR /> <P></P><P></P><P></P><P></P><BR /><BR /> <P></P><P></P><P></P><P></P><P></P><P>%ClaveCuenta</P><BR /><BR /> <P></P><P></P><P></P><P>,</P><P></P><P>JV$INP</P><BR /><BR /> <P></P><P></P><P></P><P>,</P><P></P><P>KGICUO</P><BR /><BR /> <P></P><P></P><P></P><P>,</P><P></P><P>KG$CUC</P><BR /><BR /> <P></P><P></P><P></P><P>,</P><P></P><P></P><P></P><P>IF</P><BR /><BR /> <P></P><P></P><P>(%ClaveCuenta &lt;&gt; PREVIOUS(%ClaveCuenta), JV$INP, PREVIOUS(Saldo)- PREVIOUS(KG$CUC)) <B>AS</B></P><P></P><P>Saldo</P><P></P><P></P><BR /><BR /> <P></P><P></P><P></P><P style="font-weight: bold"></P><P style="font-weight: bold">FROM</P><BR /><BR /> <P></P><P>C:\Qlikview\Datos\txt\Pa\PRO000_temp1.qvd (qvd)</P><P></P><P>;</P><P></P><P></P><BR /><BR /></BODY></HTML> Tue, 06 Oct 2009 01:56:01 GMT 2009-10-06T01:56:01Z Consulta : Corte de Control https://community.qlik.com/t5/QlikView/Consulta-Corte-de-Control/m-p/206863#M62814 <HTML><HEAD></HEAD><BODY><P>Si tengo una tabla con</P><P>nro_prestamo, nro_cuota, saldo e importe que se resta al saldo por cada cuota, menos la primera,</P><P></P><P>Como hago un corte de control?</P></BODY></HTML> Mon, 05 Oct 2009 22:53:32 GMT https://community.qlik.com/t5/QlikView/Consulta-Corte-de-Control/m-p/206863#M62814 2009-10-05T22:53:32Z Consulta : Corte de Control https://community.qlik.com/t5/QlikView/Consulta-Corte-de-Control/m-p/206864#M62815 <HTML><HEAD></HEAD><BODY><P>según lo que recuerdo es un corte de control, se me ocurre con un tabla pivote y usando prestamo y cuota como dimensiones?</P><P></P><P>Si no entendí bien, te pido postees una imágen con cómo está tu información y cómo la quieres visualizar.</P></BODY></HTML> Mon, 05 Oct 2009 23:06:43 GMT https://community.qlik.com/t5/QlikView/Consulta-Corte-de-Control/m-p/206864#M62815 2009-10-05T23:06:43Z Consulta : Corte de Control https://community.qlik.com/t5/QlikView/Consulta-Corte-de-Control/m-p/206865#M62816 <HTML><HEAD></HEAD><BODY><P></P><P>Quisiera que el ultimo campo, al cual yo llamo Saldo, se vaya calculando por cada registro</P><P></P><P></P><BR /><BR /> <P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width:539pt;border-collapse:collapse;" width="718"><COLGROUP><COL span="3" style="width:60pt;" width="80" /><COL style="width:119pt;mso-width-source:userset;mso-width-alt:5778;" width="158" /><COL span="4" style="width:60pt;" width="80" /></COLGROUP><TBODY><TR style="height:12.75pt;"><TD height="17" style="width:60pt;height:12.75pt;background-color:transparent;border:#d4d0c8;" width="80">Credito</TD><TD style="width:60pt;background-color:transparent;border:#d4d0c8;" width="80">Importe</TD><TD style="width:60pt;background-color:transparent;border:#d4d0c8;" width="80">Cuota</TD><TD style="width:119pt;background-color:transparent;border:#d4d0c8;" width="158">Importe a restar del saldo</TD><TD style="width:60pt;background-color:transparent;border:#d4d0c8;" width="80">Saldo</TD><TD style="width:60pt;background-color:transparent;border:#d4d0c8;" width="80"></TD><TD style="width:60pt;background-color:transparent;border:#d4d0c8;" width="80"></TD><TD style="width:60pt;background-color:transparent;border:#d4d0c8;" width="80"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">27,02</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD colspan="2" style="background-color:transparent;mso-ignore:colspan;border:#d4d0c8;">Ej: 2474,23-27,02 = 2447,21</TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">60,26</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2447,21</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">3</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">63,17</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2386,95</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">4</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">66,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2323,78</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">5</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">69,43</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2257,55</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">6</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">72,79</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2188,12</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">7</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">76,32</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2115,33</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">8</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">80,01</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2039,01</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">9</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">83,88</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">1959</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">10</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">87,94</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">1875,12</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">11</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">92,2</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">1787,18</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">12</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">96,66</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">1694,98</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">13</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">101,35</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">1598,32</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">14</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">106,26</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">1496,97</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">15</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">111,4</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">1390,71</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">16</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">116,79</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">1279,31</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">17</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">122,44</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">1162,52</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">18</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">128,37</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">1040,08</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">19</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">134,57</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">911,71</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">20</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">141,1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">777,14</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">21</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">147,92</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">636,04</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">22</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">155,07</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">488,12</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">162,59</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">333,05</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR><TR style="height:12.75pt;"><TD align="right" height="17" style="height:12.75pt;background-color:transparent;border:#d4d0c8;">1</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">2474,23</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">24</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">170,46</TD><TD align="right" style="background-color:transparent;border:#d4d0c8;">170,46</TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD><TD style="background-color:transparent;border:#d4d0c8;"></TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P><I>PRO000_temp2:</I></P><P style="font-weight: bold"></P><P style="font-weight: bold">noconcatenate</P><B></B><P style="font-weight: bold">LOAD</P><BR /><BR /> <P></P><P></P><P></P><P></P><BR /><BR /> <P></P><P></P><P></P><P></P><P></P><P>%ClaveCuenta</P><BR /><BR /> <P></P><P></P><P></P><P>,</P><P></P><P>JV$INP</P><BR /><BR /> <P></P><P></P><P></P><P>,</P><P></P><P>KGICUO</P><BR /><BR /> <P></P><P></P><P></P><P>,</P><P></P><P>KG$CUC</P><BR /><BR /> <P></P><P></P><P></P><P>,</P><P></P><P></P><P></P><P>IF</P><BR /><BR /> <P></P><P></P><P>(%ClaveCuenta &lt;&gt; PREVIOUS(%ClaveCuenta), JV$INP, PREVIOUS(Saldo)- PREVIOUS(KG$CUC)) <B>AS</B></P><P></P><P>Saldo</P><P></P><P></P><BR /><BR /> <P></P><P></P><P></P><P style="font-weight: bold"></P><P style="font-weight: bold">FROM</P><BR /><BR /> <P></P><P>C:\Qlikview\Datos\txt\Pa\PRO000_temp1.qvd (qvd)</P><P></P><P>;</P><P></P><P></P><BR /><BR /></BODY></HTML> Tue, 06 Oct 2009 01:56:01 GMT https://community.qlik.com/t5/QlikView/Consulta-Corte-de-Control/m-p/206865#M62816 2009-10-06T01:56:01Z