topic PROBLEMA EN ABOVE in QlikView https://community.qlik.com/t5/QlikView/PROBLEMA-EN-ABOVE/m-p/604459#M223383 <HTML><HEAD></HEAD><BODY><P>Hola Comunidad</P><P>Muchas gracias de antemano.</P><P></P><P>tengo el siguiente problema</P><P></P><P>1.- mi tabla original es la siguiente</P><P></P><TABLE border="1" class="jiveBorder" height="223" style="border: 1px solid #000000; width: 228px; height: 170px;" width="227"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 1</STRONG></TH></TR><TR><TD style="padding: 2px;"><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 198px;"><TBODY><TR><TD class="xl65" height="17" width="70">MES_AÑO</TD><TD class="xl65" style="border-left: none;" width="68">No_LOTE</TD><TD class="xl65" style="border-left: none;" width="60">PRUEBA</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Ene 2013</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">156</SPAN></TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">25/01/2013</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Mar 2013</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">157</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">26/03/2013</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Abr 2013</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">156</SPAN></TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">30/04/2013</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Abr 2013</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">158</SPAN></TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">09/04/2013</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">May 2013</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">158</SPAN></TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">07/05/2013</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">May 2013</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">159</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">13/05/2013</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Jun 2013</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">160</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">01/06/2013</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><P></P><P>para quitar el No LOTE repetido utilizo el siguiente SET análisis</P><P></P><P>IF(</P><P>SUM({$&lt;CLAVE_DESA_PROY={'AVRH00001'},CLASEMOV_REAL= {'101','102'}&gt;} CANTIDAD_REAL) &gt; '1',</P><P>DATE (MIN({$&lt;CLAVE_DESA_PROY={'AVRH00001'},CLASEMOV_REAL= {'101','102'}&gt;} FECHA)),NULL())</P><P></P><P>y me queda la siguiente tabla</P><P></P><TABLE border="1" class="jiveBorder" height="273" style="border: 1px solid rgb(0, 0, 0); width: 231px; height: 127px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P><STRONG>Header 1</STRONG></P></TH></TR><TR><TD style="padding: 2px;"><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 198px;"><TBODY><TR><TD class="xl65" height="17" width="70">MES_AÑO</TD><TD class="xl65" style="border-left: none;" width="68">No_LOTE</TD><TD class="xl65" style="border-left: none;" width="60">PRUEBA</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Ene 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">156</TD><TD class="xl66" style="border-top: none; border-left: none;">25/01/2013</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Mar 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">157</TD><TD class="xl66" style="border-top: none; border-left: none;">26/03/2013</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Abr 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">158</TD><TD class="xl66" style="border-top: none; border-left: none;">09/04/2013</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">May 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">159</TD><TD class="xl66" style="border-top: none; border-left: none;">13/05/2013</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Jun 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">160</TD><TD class="xl66" style="border-top: none; border-left: none;">01/06/2013</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Jul 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">161</TD><TD class="xl66" style="border-top: none; border-left: none;">23/07/2013</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Sep 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">162</TD><TD class="xl66" style="border-top: none; border-left: none;">03/09/2013</TD></TR></TBODY></TABLE></TD></TR><TR><TD></TD></TR><TR><TD></TD></TR></TBODY></TABLE><P></P><P>solo que al usar el above, regresa los registros que ya estaban ocultos</P><P></P><TABLE border="1" class="jiveBorder" height="272" style="border: 1px solid rgb(0, 0, 0); width: 336px; height: 194px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 1</STRONG></TH></TR><TR><TD style="padding: 2px;"><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 284px;"><TBODY><TR><TD class="xl65" height="17" width="60">MES_AÑO</TD><TD class="xl65" style="border-left: none;" width="66">No_LOTE</TD><TD class="xl65" style="border-left: none;" width="60">PRUEBA</TD><TD class="xl65" style="border-left: none;" width="98">Above(PRUEBA)</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Ene 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">156</TD><TD class="xl66" style="border-top: none; border-left: none;">25/01/2013</TD><TD class="xl66" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Mar 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">157</TD><TD class="xl66" style="border-top: none; border-left: none;">26/03/2013</TD><TD class="xl66" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Abr 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">156</TD><TD class="xl66" style="border-top: none; border-left: none;">-</TD><TD class="xl66" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Abr 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">158</TD><TD class="xl66" style="border-top: none; border-left: none;">09/04/2013</TD><TD class="xl66" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">May 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">158</TD><TD class="xl66" style="border-top: none; border-left: none;">-</TD><TD class="xl66" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">May 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">159</TD><TD class="xl66" style="border-top: none; border-left: none;">13/05/2013</TD><TD class="xl66" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Jun 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">160</TD><TD class="xl66" style="border-top: none; border-left: none;">01/06/2013</TD><TD class="xl66" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Jul 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">161</TD><TD class="xl66" style="border-top: none; border-left: none;">23/07/2013</TD><TD class="xl66" style="border-top: none; border-left: none;">-</TD></TR></TBODY></TABLE></TD></TR><TR><TD></TD></TR></TBODY></TABLE><P></P><P>ya utilice lo siguiente:</P><P></P><P>=IF(</P><P>SUM({$&lt;CLAVE_DESA_PROY={'AVRH00001'},CLASEMOV_REAL= {'101','102'}&gt;} CANTIDAD_REAL) &gt; '1',</P><P>DATE (MIN({$&lt;CLAVE_DESA_PROY={'AVRH00001'},CLASEMOV_REAL= {'101','102'}&gt;} FECHA)),NULL())- </P><P>above(TOTAL IF(</P><P>SUM({$&lt;CLAVE_DESA_PROY={'AVRH00001'},CLASEMOV_REAL= {'101','102'}&gt;} CANTIDAD_REAL) &gt; '1',</P><P>DATE (MIN({$&lt;CLAVE_DESA_PROY={'AVRH00001'},CLASEMOV_REAL= {'101','102'}&gt;} FECHA)),NULL()))</P><P></P><P>alguien me puede ayudar. Saludos</P></BODY></HTML> Thu, 20 Mar 2014 23:41:40 GMT 2014-03-20T23:41:40Z PROBLEMA EN ABOVE https://community.qlik.com/t5/QlikView/PROBLEMA-EN-ABOVE/m-p/604459#M223383 <HTML><HEAD></HEAD><BODY><P>Hola Comunidad</P><P>Muchas gracias de antemano.</P><P></P><P>tengo el siguiente problema</P><P></P><P>1.- mi tabla original es la siguiente</P><P></P><TABLE border="1" class="jiveBorder" height="223" style="border: 1px solid #000000; width: 228px; height: 170px;" width="227"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 1</STRONG></TH></TR><TR><TD style="padding: 2px;"><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 198px;"><TBODY><TR><TD class="xl65" height="17" width="70">MES_AÑO</TD><TD class="xl65" style="border-left: none;" width="68">No_LOTE</TD><TD class="xl65" style="border-left: none;" width="60">PRUEBA</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Ene 2013</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">156</SPAN></TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">25/01/2013</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Mar 2013</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">157</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">26/03/2013</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Abr 2013</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">156</SPAN></TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">30/04/2013</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Abr 2013</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">158</SPAN></TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">09/04/2013</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">May 2013</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">158</SPAN></TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">07/05/2013</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">May 2013</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">159</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">13/05/2013</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Jun 2013</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">160</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">01/06/2013</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><P></P><P>para quitar el No LOTE repetido utilizo el siguiente SET análisis</P><P></P><P>IF(</P><P>SUM({$&lt;CLAVE_DESA_PROY={'AVRH00001'},CLASEMOV_REAL= {'101','102'}&gt;} CANTIDAD_REAL) &gt; '1',</P><P>DATE (MIN({$&lt;CLAVE_DESA_PROY={'AVRH00001'},CLASEMOV_REAL= {'101','102'}&gt;} FECHA)),NULL())</P><P></P><P>y me queda la siguiente tabla</P><P></P><TABLE border="1" class="jiveBorder" height="273" style="border: 1px solid rgb(0, 0, 0); width: 231px; height: 127px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P><STRONG>Header 1</STRONG></P></TH></TR><TR><TD style="padding: 2px;"><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 198px;"><TBODY><TR><TD class="xl65" height="17" width="70">MES_AÑO</TD><TD class="xl65" style="border-left: none;" width="68">No_LOTE</TD><TD class="xl65" style="border-left: none;" width="60">PRUEBA</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Ene 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">156</TD><TD class="xl66" style="border-top: none; border-left: none;">25/01/2013</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Mar 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">157</TD><TD class="xl66" style="border-top: none; border-left: none;">26/03/2013</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Abr 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">158</TD><TD class="xl66" style="border-top: none; border-left: none;">09/04/2013</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">May 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">159</TD><TD class="xl66" style="border-top: none; border-left: none;">13/05/2013</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Jun 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">160</TD><TD class="xl66" style="border-top: none; border-left: none;">01/06/2013</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Jul 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">161</TD><TD class="xl66" style="border-top: none; border-left: none;">23/07/2013</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Sep 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">162</TD><TD class="xl66" style="border-top: none; border-left: none;">03/09/2013</TD></TR></TBODY></TABLE></TD></TR><TR><TD></TD></TR><TR><TD></TD></TR></TBODY></TABLE><P></P><P>solo que al usar el above, regresa los registros que ya estaban ocultos</P><P></P><TABLE border="1" class="jiveBorder" height="272" style="border: 1px solid rgb(0, 0, 0); width: 336px; height: 194px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 1</STRONG></TH></TR><TR><TD style="padding: 2px;"><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 284px;"><TBODY><TR><TD class="xl65" height="17" width="60">MES_AÑO</TD><TD class="xl65" style="border-left: none;" width="66">No_LOTE</TD><TD class="xl65" style="border-left: none;" width="60">PRUEBA</TD><TD class="xl65" style="border-left: none;" width="98">Above(PRUEBA)</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Ene 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">156</TD><TD class="xl66" style="border-top: none; border-left: none;">25/01/2013</TD><TD class="xl66" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Mar 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">157</TD><TD class="xl66" style="border-top: none; border-left: none;">26/03/2013</TD><TD class="xl66" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Abr 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">156</TD><TD class="xl66" style="border-top: none; border-left: none;">-</TD><TD class="xl66" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Abr 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">158</TD><TD class="xl66" style="border-top: none; border-left: none;">09/04/2013</TD><TD class="xl66" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">May 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">158</TD><TD class="xl66" style="border-top: none; border-left: none;">-</TD><TD class="xl66" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">May 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">159</TD><TD class="xl66" style="border-top: none; border-left: none;">13/05/2013</TD><TD class="xl66" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Jun 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">160</TD><TD class="xl66" style="border-top: none; border-left: none;">01/06/2013</TD><TD class="xl66" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Jul 2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">161</TD><TD class="xl66" style="border-top: none; border-left: none;">23/07/2013</TD><TD class="xl66" style="border-top: none; border-left: none;">-</TD></TR></TBODY></TABLE></TD></TR><TR><TD></TD></TR></TBODY></TABLE><P></P><P>ya utilice lo siguiente:</P><P></P><P>=IF(</P><P>SUM({$&lt;CLAVE_DESA_PROY={'AVRH00001'},CLASEMOV_REAL= {'101','102'}&gt;} CANTIDAD_REAL) &gt; '1',</P><P>DATE (MIN({$&lt;CLAVE_DESA_PROY={'AVRH00001'},CLASEMOV_REAL= {'101','102'}&gt;} FECHA)),NULL())- </P><P>above(TOTAL IF(</P><P>SUM({$&lt;CLAVE_DESA_PROY={'AVRH00001'},CLASEMOV_REAL= {'101','102'}&gt;} CANTIDAD_REAL) &gt; '1',</P><P>DATE (MIN({$&lt;CLAVE_DESA_PROY={'AVRH00001'},CLASEMOV_REAL= {'101','102'}&gt;} FECHA)),NULL()))</P><P></P><P>alguien me puede ayudar. Saludos</P></BODY></HTML> Thu, 20 Mar 2014 23:41:40 GMT https://community.qlik.com/t5/QlikView/PROBLEMA-EN-ABOVE/m-p/604459#M223383 2014-03-20T23:41:40Z