topic Ayuda con Set Analysis // Help with set analysis in QlikView https://community.qlik.com/t5/QlikView/Ayuda-con-Set-Analysis-Help-with-set-analysis/m-p/780963#M471952 <HTML><HEAD></HEAD><BODY><P><BR />Amigos, buen día, tengo una consulta. Cuando realizo una tabla con la expresion que más abajo indico me devuelve los mismos valores para todas las filas, en cambio si selecciono un mes en particular me devuelve el valor correcto. Que podría ser?</P><P></P><P>Saludos y muchas Gracias</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 392px; border-collapse: collapse;"><TBODY><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border-width: 1pt 1pt 0.5pt 0.5pt; border-style: solid; border-color: gainsboro; width: 74pt; height: 12.75pt; background-color: whitesmoke;" width="98"><STRONG style="color: #333333; font-family: Tahoma;">MonthYear</STRONG></TD><TD class="xl64" style="border: 0.5pt solid gainsboro; width: 74pt; background-color: white;" width="98"><SPAN style="color: #333333; font-family: Tahoma;"># Vidas Sección 7</SPAN></TD><TD class="xl64" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 74pt; background-color: white;" width="98"><SPAN style="color: #333333; font-family: Tahoma;"># Vidas Sección 21</SPAN></TD><TD class="xl64" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 74pt; background-color: white;" width="98"><SPAN style="color: #333333; font-family: Tahoma;"># Vidas Sección 23</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">ene-2013</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">114218</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">225</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">5488</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">feb-2013</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">114218</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">225</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">5488</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">mar-2013</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">114218</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">225</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">5488</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">abr-2013</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">114218</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">225</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">5488</SPAN></TD></TR></TBODY></TABLE><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 392px; border-collapse: collapse;"><TBODY><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border-width: 1pt 1pt 0.5pt 0.5pt; border-style: solid; border-color: gainsboro; width: 74pt; height: 12.75pt; background-color: whitesmoke;" width="98"><STRONG style="color: #333333; font-family: Tahoma;">MonthYear</STRONG></TD><TD class="xl64" style="border: 0.5pt solid gainsboro; width: 74pt; background-color: white;" width="98"><SPAN style="color: #333333; font-family: Tahoma;"># Vidas Sección 7</SPAN></TD><TD class="xl64" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 74pt; background-color: white;" width="98"><SPAN style="color: #333333; font-family: Tahoma;"># Vidas Sección 21</SPAN></TD><TD class="xl64" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 74pt; background-color: white;" width="98"><SPAN style="color: #333333; font-family: Tahoma;"># Vidas Sección 23</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">ene-2013</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">398764</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">225</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">129482</SPAN></TD></TR></TBODY></TABLE><P></P><P>DIMENSION</P><P></P><P>MonthYear (Devuelve Ene-2013</P><P></P><P></P><P>EXPRESION</P><P>count&nbsp; <SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">SECCION</SPAN><SPAN style="font-size: 8pt;">={7}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">Estado</SPAN><SPAN style="font-size: 8pt;">={'A'}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Filtro Fecha de Ingreso]</SPAN><SPAN style="font-size: 8pt;">={'OK'}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">MES_ID_INGRESO</SPAN><SPAN style="font-size: 8pt;"> = {</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&lt;=$(vMaxMonthSel)"</SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Seccion-Poliza-Grupo]</SPAN><SPAN style="font-size: 8pt;">) + </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">SECCION</SPAN><SPAN style="font-size: 8pt;">={7},</SPAN><SPAN style="color: #800000; font-size: 8pt;">ESTADO</SPAN><SPAN style="font-size: 8pt;">={'B','M'}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Filtro Fecha de Ingreso]</SPAN><SPAN style="font-size: 8pt;">={'OK'} , </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Filtro Fecha de Baja]</SPAN><SPAN style="font-size: 8pt;">={'OK'}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">MES_ID_BAJA</SPAN><SPAN style="font-size: 8pt;"> = {</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&gt;$(vMaxMonthSel)"</SPAN><SPAN style="font-size: 8pt;">}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">MES_ID_INGRESO</SPAN><SPAN style="font-size: 8pt;"> = {</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&lt;=$(vMaxMonthSel)"</SPAN><SPAN style="font-size: 8pt;">} &gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Seccion-Poliza-Grupo]</SPAN><SPAN style="font-size: 8pt;">) + </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">SECCION</SPAN><SPAN style="font-size: 8pt;">={7},</SPAN><SPAN style="color: #800000; font-size: 8pt;">Estado</SPAN><SPAN style="font-size: 8pt;">={'R'}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Filtro Fecha de Ingreso]</SPAN><SPAN style="font-size: 8pt;">={'OK'}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">MES_ID_REHABILITACION</SPAN><SPAN style="font-size: 8pt;">= {</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&lt;=$(vMaxMonthSel)"</SPAN><SPAN style="font-size: 8pt;">}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">MES_ID_INGRESO</SPAN><SPAN style="font-size: 8pt;"> = {</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&lt;=$(vMaxMonthSel)"</SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Seccion-Poliza-Grupo]</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P></BODY></HTML> Tue, 10 Feb 2015 21:46:51 GMT jumiprado 2015-02-10T21:46:51Z Ayuda con Set Analysis // Help with set analysis https://community.qlik.com/t5/QlikView/Ayuda-con-Set-Analysis-Help-with-set-analysis/m-p/780963#M471952 <HTML><HEAD></HEAD><BODY><P><BR />Amigos, buen día, tengo una consulta. Cuando realizo una tabla con la expresion que más abajo indico me devuelve los mismos valores para todas las filas, en cambio si selecciono un mes en particular me devuelve el valor correcto. Que podría ser?</P><P></P><P>Saludos y muchas Gracias</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 392px; border-collapse: collapse;"><TBODY><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border-width: 1pt 1pt 0.5pt 0.5pt; border-style: solid; border-color: gainsboro; width: 74pt; height: 12.75pt; background-color: whitesmoke;" width="98"><STRONG style="color: #333333; font-family: Tahoma;">MonthYear</STRONG></TD><TD class="xl64" style="border: 0.5pt solid gainsboro; width: 74pt; background-color: white;" width="98"><SPAN style="color: #333333; font-family: Tahoma;"># Vidas Sección 7</SPAN></TD><TD class="xl64" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 74pt; background-color: white;" width="98"><SPAN style="color: #333333; font-family: Tahoma;"># Vidas Sección 21</SPAN></TD><TD class="xl64" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 74pt; background-color: white;" width="98"><SPAN style="color: #333333; font-family: Tahoma;"># Vidas Sección 23</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">ene-2013</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">114218</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">225</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">5488</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">feb-2013</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">114218</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">225</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">5488</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">mar-2013</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">114218</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">225</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">5488</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">abr-2013</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">114218</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">225</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">5488</SPAN></TD></TR></TBODY></TABLE><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 392px; border-collapse: collapse;"><TBODY><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border-width: 1pt 1pt 0.5pt 0.5pt; border-style: solid; border-color: gainsboro; width: 74pt; height: 12.75pt; background-color: whitesmoke;" width="98"><STRONG style="color: #333333; font-family: Tahoma;">MonthYear</STRONG></TD><TD class="xl64" style="border: 0.5pt solid gainsboro; width: 74pt; background-color: white;" width="98"><SPAN style="color: #333333; font-family: Tahoma;"># Vidas Sección 7</SPAN></TD><TD class="xl64" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 74pt; background-color: white;" width="98"><SPAN style="color: #333333; font-family: Tahoma;"># Vidas Sección 21</SPAN></TD><TD class="xl64" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 74pt; background-color: white;" width="98"><SPAN style="color: #333333; font-family: Tahoma;"># Vidas Sección 23</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">ene-2013</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">398764</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">225</SPAN></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">129482</SPAN></TD></TR></TBODY></TABLE><P></P><P>DIMENSION</P><P></P><P>MonthYear (Devuelve Ene-2013</P><P></P><P></P><P>EXPRESION</P><P>count&nbsp; <SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">SECCION</SPAN><SPAN style="font-size: 8pt;">={7}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">Estado</SPAN><SPAN style="font-size: 8pt;">={'A'}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Filtro Fecha de Ingreso]</SPAN><SPAN style="font-size: 8pt;">={'OK'}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">MES_ID_INGRESO</SPAN><SPAN style="font-size: 8pt;"> = {</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&lt;=$(vMaxMonthSel)"</SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Seccion-Poliza-Grupo]</SPAN><SPAN style="font-size: 8pt;">) + </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">SECCION</SPAN><SPAN style="font-size: 8pt;">={7},</SPAN><SPAN style="color: #800000; font-size: 8pt;">ESTADO</SPAN><SPAN style="font-size: 8pt;">={'B','M'}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Filtro Fecha de Ingreso]</SPAN><SPAN style="font-size: 8pt;">={'OK'} , </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Filtro Fecha de Baja]</SPAN><SPAN style="font-size: 8pt;">={'OK'}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">MES_ID_BAJA</SPAN><SPAN style="font-size: 8pt;"> = {</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&gt;$(vMaxMonthSel)"</SPAN><SPAN style="font-size: 8pt;">}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">MES_ID_INGRESO</SPAN><SPAN style="font-size: 8pt;"> = {</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&lt;=$(vMaxMonthSel)"</SPAN><SPAN style="font-size: 8pt;">} &gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Seccion-Poliza-Grupo]</SPAN><SPAN style="font-size: 8pt;">) + </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">SECCION</SPAN><SPAN style="font-size: 8pt;">={7},</SPAN><SPAN style="color: #800000; font-size: 8pt;">Estado</SPAN><SPAN style="font-size: 8pt;">={'R'}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Filtro Fecha de Ingreso]</SPAN><SPAN style="font-size: 8pt;">={'OK'}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">MES_ID_REHABILITACION</SPAN><SPAN style="font-size: 8pt;">= {</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&lt;=$(vMaxMonthSel)"</SPAN><SPAN style="font-size: 8pt;">}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">MES_ID_INGRESO</SPAN><SPAN style="font-size: 8pt;"> = {</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&lt;=$(vMaxMonthSel)"</SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Seccion-Poliza-Grupo]</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P></BODY></HTML> Tue, 10 Feb 2015 21:46:51 GMT https://community.qlik.com/t5/QlikView/Ayuda-con-Set-Analysis-Help-with-set-analysis/m-p/780963#M471952 jumiprado 2015-02-10T21:46:51Z