topic PROBLEMAS CON SET ANALYSIS Y RGB in Español https://community.qlik.com/t5/Espa%C3%B1ol/PROBLEMAS-CON-SET-ANALYSIS-Y-RGB/m-p/1032947#M10136 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000;">Buenos días,</SPAN></P><P></P><P><SPAN style="color: #000000;">Estoy trabajando una tabla de Evaluación de Desempeño para la cual tengo dos datos base, el nombre del colaborador, y su producción (<STRONG>POND. TOTAL</STRONG>), la idea es establecer una meta de producción para el periodo de evaluación.</SPAN></P><P><IMG __jive_id="122909" alt="Captura 001.PNG" class="jive-image image-1" src="/legacyfs/online/122909_Captura 001.PNG" style="color: #000000; font-size: 13.3333px;" /></P><UL><LI><SPAN style="color: #000000;">La columna <STRONG>POND. TOTAL</STRONG> fue calculada de la siguiente manera:</SPAN></LI></UL><P style="padding-left: 30px;"><SPAN style="font-size: 10pt; line-height: 1.5em; color: #0000ff;">Sum</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em; color: #000000;"> (</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em; color: #000000;">)</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em; color: #000000;"><BR /></SPAN></P><P style="padding-left: 30px;"></P><UL><LI><SPAN style="color: #000000;">La columna <STRONG>PROMEDIO</STRONG> fue calculada de la siguiente manera:</SPAN></LI></UL><P style="padding-left: 30px;"><SPAN style="color: #000000;"><SPAN style="color: #0000ff;">AVG</SPAN>(<SPAN style="color: #0000ff;">TOTAL</SPAN>(<SPAN style="color: #0000ff;">AGGR</SPAN>(<SPAN style="color: #0000ff;">SUM</SPAN>(<SPAN style="color: #800000;">[POND. TOTAL]</SPAN>),<SPAN style="color: #800000;">COLABORADOR</SPAN>)))</SPAN><SPAN style="color: #000000;"><BR /></SPAN></P><UL><LI><SPAN style="color: #000000;">La columna <STRONG>DESVESTA</STRONG> fue calculada de la siguiente manera:</SPAN></LI></UL><P style="padding-left: 30px;"><SPAN><SPAN style="color: #0000ff;">STDEV</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="color: #0000ff; font-size: 13.3333px;">TOTAL</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">AGGR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">SUM</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">),</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">COLABORADOR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">)))</SPAN></SPAN><SPAN style="color: #000000; font-size: 13.3333px;"><BR /></SPAN></P><UL><LI><SPAN style="color: #000000;">La columna <STRONG>L. S.</STRONG> fue calculada de la siguiente manera:</SPAN></LI></UL><P style="padding-left: 30px;"><SPAN style="color: #000000;"><SPAN style="font-size: 13.3333px; color: #0000ff;">AVG</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="color: #0000ff; font-size: 13.3333px;">TOTAL</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">AGGR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">SUM</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">),</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">COLABORADOR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">))) + <SPAN style="color: #0000ff;">STDEV</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="color: #0000ff; font-size: 13.3333px;">TOTAL</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">AGGR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">SUM</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">),</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">COLABORADOR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">)))</SPAN></SPAN></SPAN><SPAN style="color: #000000; font-size: 13.3333px;"><BR /></SPAN></P><UL><LI><SPAN style="color: #000000;">La columna <STRONG>L. I.</STRONG> fue calculada de la siguiente manera:</SPAN></LI></UL><P style="padding-left: 30px;"><SPAN style="color: #000000;"><SPAN style="font-size: 13.3333px; color: #0000ff;">AVG</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="color: #0000ff; font-size: 13.3333px;">TOTAL</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">AGGR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">SUM</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">),</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">COLABORADOR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">))) - <SPAN style="color: #0000ff;">STDEV</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="color: #0000ff; font-size: 13.3333px;">TOTAL</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">AGGR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">SUM</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">),</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">COLABORADOR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">)))</SPAN></SPAN></SPAN><SPAN style="color: #000000; font-size: 13.3333px;"><BR /></SPAN></P><UL><LI><SPAN style="color: #000000;">La columna <STRONG>DIF. 1</STRONG> fue calculada de la siguiente manera:</SPAN></LI></UL><P style="padding-left: 30px;"><SPAN style="color: #000000;"><SPAN style="font-size: 10pt; color: #0000ff;">Sum</SPAN><SPAN style="font-size: 10pt; color: #000000;"> (</SPAN><SPAN style="font-size: 10pt; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="font-size: 10pt; color: #000000;">) - (<SPAN style="font-size: 13.3333px; color: #0000ff;">AVG</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="color: #0000ff; font-size: 13.3333px;">TOTAL</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">AGGR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">SUM</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">),</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">COLABORADOR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">))) + <SPAN style="color: #0000ff;">STDEV</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="color: #0000ff; font-size: 13.3333px;">TOTAL</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">AGGR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">SUM</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">),</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">COLABORADOR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">))))</SPAN></SPAN></SPAN></SPAN><SPAN style="color: #000000; font-size: 13.3333px;"><BR /></SPAN></P><UL><LI><SPAN style="color: #000000;">La columna <STRONG>DIF. 2</STRONG> fue calculada de la siguiente manera:</SPAN></LI></UL><P style="padding-left: 30px;"><SPAN style="color: #000000;"><SPAN style="font-size: 10pt; color: #0000ff;">Sum</SPAN><SPAN style="font-size: 10pt; color: #000000;"> (</SPAN><SPAN style="font-size: 10pt; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="font-size: 10pt; color: #000000;">) - (<SPAN style="font-size: 13.3333px; color: #0000ff;">AVG</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="color: #0000ff; font-size: 13.3333px;">TOTAL</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">AGGR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">SUM</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">),</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">COLABORADOR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">))) - <SPAN style="color: #0000ff;">STDEV</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="color: #0000ff; font-size: 13.3333px;">TOTAL</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">AGGR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">SUM</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">),</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">COLABORADOR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">))))</SPAN></SPAN></SPAN></SPAN></P><P></P><P><SPAN style="color: #000000;">Adicionalmente a ello, establecí un formato condicional a las columnas <STRONG>DIF. 1</STRONG>, <STRONG>DIF. 2</STRONG> y <STRONG>POND. TOTAL</STRONG>:</SPAN></P><UL><LI><SPAN style="color: #000000;">Formato condicional para <STRONG>DIF. 1</STRONG>:</SPAN></LI></UL><P><IMG __jive_id="122910" alt="Captura 002.PNG" class="jive-image image-2" src="/legacyfs/online/122910_Captura 002.PNG" style="height: auto;" /></P><UL><LI><SPAN style="color: #000000;">Formato condicional para <STRONG>DIF. 2</STRONG>:</SPAN></LI></UL><P><IMG __jive_id="122911" alt="Captura 003.PNG" class="jive-image image-3" src="/legacyfs/online/122911_Captura 003.PNG" style="height: auto;" /></P><UL><LI><SPAN style="color: #000000;">Formato Condicional para <STRONG>POND. TOTAL</STRONG>:</SPAN></LI></UL><P style="padding-left: 30px;"><SPAN style="color: #000000;"><SPAN style="color: #0000ff;">if</SPAN>(<SPAN style="font-size: 10pt; color: #0000ff;">Sum</SPAN><SPAN style="font-size: 10pt; color: #000000;"> (</SPAN><SPAN style="font-size: 10pt; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="font-size: 10pt; color: #000000;">) - (<SPAN style="font-size: 13.3333px; color: #0000ff;">AVG</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="color: #0000ff; font-size: 13.3333px;">TOTAL</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">AGGR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">SUM</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">),</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">COLABORADOR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">))) + <SPAN style="color: #0000ff;">STDEV</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="color: #0000ff; font-size: 13.3333px;">TOTAL</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">AGGR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">SUM</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">),</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">COLABORADOR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">))))&lt;0 <SPAN style="color: #0000ff;">AND</SPAN> <SPAN style="font-size: 10pt; color: #0000ff;">Sum</SPAN><SPAN style="font-size: 10pt; color: #000000;"> (</SPAN><SPAN style="font-size: 10pt; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="font-size: 10pt; color: #000000;">) - (<SPAN style="font-size: 13.3333px; color: #0000ff;">AVG</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="color: #0000ff; font-size: 13.3333px;">TOTAL</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">AGGR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">SUM</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">),</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">COLABORADOR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">))) - <SPAN style="color: #0000ff;">STDEV</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="color: #0000ff; font-size: 13.3333px;">TOTAL</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">AGGR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">SUM</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">),</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">COLABORADOR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">))))&gt;=0,<SPAN style="color: #0000ff;">RGB</SPAN>(0,112,192))</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P><P><SPAN style="color: #000000; font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="color: #000000; font-size: 13.3333px;">Como mencioné líneas arriba, la idea es establecer una meta, por ello debo calcular <STRONG>PROMEDIO 2</STRONG>, <STRONG>DESVESTA 2</STRONG>, y <STRONG>META</STRONG>.</SPAN></P><UL><LI><SPAN style="color: #000000; font-size: 13.3333px;">El <STRONG>PROMEDIO 2</STRONG> se calcula usando los datos de <STRONG>POND. TOTAL</STRONG> con fondo azul.</SPAN></LI><LI><SPAN style="color: #000000; font-size: 13.3333px;">El <STRONG>DESVESTA 2</STRONG> se calcula usando los datos de <STRONG>POND. TOTAL</STRONG> con fondo azul.</SPAN></LI><LI><SPAN style="color: #000000; font-size: 13.3333px;">La META se calcula sumando <STRONG>PROMEDIO 2</STRONG> y <STRONG>DESVESTA 2</STRONG>.</SPAN></LI></UL><P></P><P><SPAN style="; color: #000000;"><STRONG>¿Cómo puedo calcular PROMEDIO 2</STRONG></SPAN><SPAN style="; color: #000000;"><STRONG><SPAN style="font-size: 13.3333px;">, </SPAN>DESVESTA 2<SPAN style="font-size: 13.3333px;">, y </SPAN></STRONG></SPAN><SPAN style="; color: #000000; font-size: 13.3333px;"><STRONG>META?</STRONG></SPAN></P></BODY></HTML> Wed, 27 Apr 2016 17:49:52 GMT 2016-04-27T17:49:52Z PROBLEMAS CON SET ANALYSIS Y RGB https://community.qlik.com/t5/Espa%C3%B1ol/PROBLEMAS-CON-SET-ANALYSIS-Y-RGB/m-p/1032947#M10136 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000;">Buenos días,</SPAN></P><P></P><P><SPAN style="color: #000000;">Estoy trabajando una tabla de Evaluación de Desempeño para la cual tengo dos datos base, el nombre del colaborador, y su producción (<STRONG>POND. TOTAL</STRONG>), la idea es establecer una meta de producción para el periodo de evaluación.</SPAN></P><P><IMG __jive_id="122909" alt="Captura 001.PNG" class="jive-image image-1" src="/legacyfs/online/122909_Captura 001.PNG" style="color: #000000; font-size: 13.3333px;" /></P><UL><LI><SPAN style="color: #000000;">La columna <STRONG>POND. TOTAL</STRONG> fue calculada de la siguiente manera:</SPAN></LI></UL><P style="padding-left: 30px;"><SPAN style="font-size: 10pt; line-height: 1.5em; color: #0000ff;">Sum</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em; color: #000000;"> (</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em; color: #000000;">)</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em; color: #000000;"><BR /></SPAN></P><P style="padding-left: 30px;"></P><UL><LI><SPAN style="color: #000000;">La columna <STRONG>PROMEDIO</STRONG> fue calculada de la siguiente manera:</SPAN></LI></UL><P style="padding-left: 30px;"><SPAN style="color: #000000;"><SPAN style="color: #0000ff;">AVG</SPAN>(<SPAN style="color: #0000ff;">TOTAL</SPAN>(<SPAN style="color: #0000ff;">AGGR</SPAN>(<SPAN style="color: #0000ff;">SUM</SPAN>(<SPAN style="color: #800000;">[POND. TOTAL]</SPAN>),<SPAN style="color: #800000;">COLABORADOR</SPAN>)))</SPAN><SPAN style="color: #000000;"><BR /></SPAN></P><UL><LI><SPAN style="color: #000000;">La columna <STRONG>DESVESTA</STRONG> fue calculada de la siguiente manera:</SPAN></LI></UL><P style="padding-left: 30px;"><SPAN><SPAN style="color: #0000ff;">STDEV</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="color: #0000ff; font-size: 13.3333px;">TOTAL</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">AGGR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">SUM</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">),</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">COLABORADOR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">)))</SPAN></SPAN><SPAN style="color: #000000; font-size: 13.3333px;"><BR /></SPAN></P><UL><LI><SPAN style="color: #000000;">La columna <STRONG>L. S.</STRONG> fue calculada de la siguiente manera:</SPAN></LI></UL><P style="padding-left: 30px;"><SPAN style="color: #000000;"><SPAN style="font-size: 13.3333px; color: #0000ff;">AVG</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="color: #0000ff; font-size: 13.3333px;">TOTAL</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">AGGR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">SUM</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">),</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">COLABORADOR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">))) + <SPAN style="color: #0000ff;">STDEV</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="color: #0000ff; font-size: 13.3333px;">TOTAL</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">AGGR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">SUM</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">),</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">COLABORADOR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">)))</SPAN></SPAN></SPAN><SPAN style="color: #000000; font-size: 13.3333px;"><BR /></SPAN></P><UL><LI><SPAN style="color: #000000;">La columna <STRONG>L. I.</STRONG> fue calculada de la siguiente manera:</SPAN></LI></UL><P style="padding-left: 30px;"><SPAN style="color: #000000;"><SPAN style="font-size: 13.3333px; color: #0000ff;">AVG</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="color: #0000ff; font-size: 13.3333px;">TOTAL</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">AGGR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">SUM</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">),</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">COLABORADOR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">))) - <SPAN style="color: #0000ff;">STDEV</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="color: #0000ff; font-size: 13.3333px;">TOTAL</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">AGGR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">SUM</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">),</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">COLABORADOR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">)))</SPAN></SPAN></SPAN><SPAN style="color: #000000; font-size: 13.3333px;"><BR /></SPAN></P><UL><LI><SPAN style="color: #000000;">La columna <STRONG>DIF. 1</STRONG> fue calculada de la siguiente manera:</SPAN></LI></UL><P style="padding-left: 30px;"><SPAN style="color: #000000;"><SPAN style="font-size: 10pt; color: #0000ff;">Sum</SPAN><SPAN style="font-size: 10pt; color: #000000;"> (</SPAN><SPAN style="font-size: 10pt; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="font-size: 10pt; color: #000000;">) - (<SPAN style="font-size: 13.3333px; color: #0000ff;">AVG</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="color: #0000ff; font-size: 13.3333px;">TOTAL</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">AGGR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">SUM</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">),</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">COLABORADOR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">))) + <SPAN style="color: #0000ff;">STDEV</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="color: #0000ff; font-size: 13.3333px;">TOTAL</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">AGGR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">SUM</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">),</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">COLABORADOR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">))))</SPAN></SPAN></SPAN></SPAN><SPAN style="color: #000000; font-size: 13.3333px;"><BR /></SPAN></P><UL><LI><SPAN style="color: #000000;">La columna <STRONG>DIF. 2</STRONG> fue calculada de la siguiente manera:</SPAN></LI></UL><P style="padding-left: 30px;"><SPAN style="color: #000000;"><SPAN style="font-size: 10pt; color: #0000ff;">Sum</SPAN><SPAN style="font-size: 10pt; color: #000000;"> (</SPAN><SPAN style="font-size: 10pt; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="font-size: 10pt; color: #000000;">) - (<SPAN style="font-size: 13.3333px; color: #0000ff;">AVG</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="color: #0000ff; font-size: 13.3333px;">TOTAL</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">AGGR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">SUM</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">),</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">COLABORADOR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">))) - <SPAN style="color: #0000ff;">STDEV</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="color: #0000ff; font-size: 13.3333px;">TOTAL</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">AGGR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">SUM</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">),</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">COLABORADOR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">))))</SPAN></SPAN></SPAN></SPAN></P><P></P><P><SPAN style="color: #000000;">Adicionalmente a ello, establecí un formato condicional a las columnas <STRONG>DIF. 1</STRONG>, <STRONG>DIF. 2</STRONG> y <STRONG>POND. TOTAL</STRONG>:</SPAN></P><UL><LI><SPAN style="color: #000000;">Formato condicional para <STRONG>DIF. 1</STRONG>:</SPAN></LI></UL><P><IMG __jive_id="122910" alt="Captura 002.PNG" class="jive-image image-2" src="/legacyfs/online/122910_Captura 002.PNG" style="height: auto;" /></P><UL><LI><SPAN style="color: #000000;">Formato condicional para <STRONG>DIF. 2</STRONG>:</SPAN></LI></UL><P><IMG __jive_id="122911" alt="Captura 003.PNG" class="jive-image image-3" src="/legacyfs/online/122911_Captura 003.PNG" style="height: auto;" /></P><UL><LI><SPAN style="color: #000000;">Formato Condicional para <STRONG>POND. TOTAL</STRONG>:</SPAN></LI></UL><P style="padding-left: 30px;"><SPAN style="color: #000000;"><SPAN style="color: #0000ff;">if</SPAN>(<SPAN style="font-size: 10pt; color: #0000ff;">Sum</SPAN><SPAN style="font-size: 10pt; color: #000000;"> (</SPAN><SPAN style="font-size: 10pt; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="font-size: 10pt; color: #000000;">) - (<SPAN style="font-size: 13.3333px; color: #0000ff;">AVG</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="color: #0000ff; font-size: 13.3333px;">TOTAL</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">AGGR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">SUM</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">),</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">COLABORADOR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">))) + <SPAN style="color: #0000ff;">STDEV</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="color: #0000ff; font-size: 13.3333px;">TOTAL</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">AGGR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">SUM</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">),</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">COLABORADOR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">))))&lt;0 <SPAN style="color: #0000ff;">AND</SPAN> <SPAN style="font-size: 10pt; color: #0000ff;">Sum</SPAN><SPAN style="font-size: 10pt; color: #000000;"> (</SPAN><SPAN style="font-size: 10pt; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="font-size: 10pt; color: #000000;">) - (<SPAN style="font-size: 13.3333px; color: #0000ff;">AVG</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="color: #0000ff; font-size: 13.3333px;">TOTAL</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">AGGR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">SUM</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">),</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">COLABORADOR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">))) - <SPAN style="color: #0000ff;">STDEV</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="color: #0000ff; font-size: 13.3333px;">TOTAL</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">AGGR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">SUM</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">),</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">COLABORADOR</SPAN><SPAN style="color: #000000; font-size: 13.3333px;">))))&gt;=0,<SPAN style="color: #0000ff;">RGB</SPAN>(0,112,192))</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P><P><SPAN style="color: #000000; font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="color: #000000; font-size: 13.3333px;">Como mencioné líneas arriba, la idea es establecer una meta, por ello debo calcular <STRONG>PROMEDIO 2</STRONG>, <STRONG>DESVESTA 2</STRONG>, y <STRONG>META</STRONG>.</SPAN></P><UL><LI><SPAN style="color: #000000; font-size: 13.3333px;">El <STRONG>PROMEDIO 2</STRONG> se calcula usando los datos de <STRONG>POND. TOTAL</STRONG> con fondo azul.</SPAN></LI><LI><SPAN style="color: #000000; font-size: 13.3333px;">El <STRONG>DESVESTA 2</STRONG> se calcula usando los datos de <STRONG>POND. TOTAL</STRONG> con fondo azul.</SPAN></LI><LI><SPAN style="color: #000000; font-size: 13.3333px;">La META se calcula sumando <STRONG>PROMEDIO 2</STRONG> y <STRONG>DESVESTA 2</STRONG>.</SPAN></LI></UL><P></P><P><SPAN style="; color: #000000;"><STRONG>¿Cómo puedo calcular PROMEDIO 2</STRONG></SPAN><SPAN style="; color: #000000;"><STRONG><SPAN style="font-size: 13.3333px;">, </SPAN>DESVESTA 2<SPAN style="font-size: 13.3333px;">, y </SPAN></STRONG></SPAN><SPAN style="; color: #000000; font-size: 13.3333px;"><STRONG>META?</STRONG></SPAN></P></BODY></HTML> Wed, 27 Apr 2016 17:49:52 GMT https://community.qlik.com/t5/Espa%C3%B1ol/PROBLEMAS-CON-SET-ANALYSIS-Y-RGB/m-p/1032947#M10136 2016-04-27T17:49:52Z Re: PROBLEMAS CON SET ANALYSIS Y RGB https://community.qlik.com/t5/Espa%C3%B1ol/PROBLEMAS-CON-SET-ANALYSIS-Y-RGB/m-p/1032948#M10137 <HTML><HEAD></HEAD><BODY><P>Entiendo que puede ser:</P><P>Avg(Aggr(</P><P style="padding: 0 0 0 30px; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #000000;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #0000ff;">if</SPAN>(<SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit; color: #0000ff;">Sum</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;"> (</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;">) - (<SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #0000ff;">AVG</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">(</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #0000ff;">TOTAL</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">(</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #0000ff;">AGGR</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">(</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #0000ff;">SUM</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">(</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">),</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #800000;">COLABORADOR</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">))) +<SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #0000ff;">STDEV</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">(</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #0000ff;">TOTAL</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">(</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #0000ff;">AGGR</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">(</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #0000ff;">SUM</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">(</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">),</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #800000;">COLABORADOR</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">))))&lt;0 <SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #0000ff;">AND</SPAN> <SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit; color: #0000ff;">Sum</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;"> (</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;">) - (<SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #0000ff;">AVG</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">(</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #0000ff;">TOTAL</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">(</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #0000ff;">AGGR</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">(</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #0000ff;">SUM</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">(</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">),</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #800000;">COLABORADOR</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">))) - <SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #0000ff;">STDEV</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">(</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #0000ff;">TOTAL</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">(</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #0000ff;">AGGR</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">(</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #0000ff;">SUM</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">(</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">),</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #800000;">COLABORADOR</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">))))&gt;=0,<SPAN style="font-family: inherit; font-style: inherit; font-weight: inherit; font-size: 10pt; color: #0000ff;">Sum</SPAN><SPAN style="color: #000000; font-family: inherit; font-style: inherit; font-weight: inherit; font-size: 10pt;"> (</SPAN><SPAN style="font-family: inherit; font-style: inherit; font-weight: inherit; font-size: 10pt; color: #800000;">[POND. TOTAL]</SPAN><SPAN style="color: #000000; font-family: inherit; font-style: inherit; font-weight: inherit; font-size: 10pt;">)</SPAN>)</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P><P><SPAN style="color: #000000; font-size: 13.3333px; font-style: inherit; font-family: inherit; font-weight: inherit;">, COLABORADOR))<BR /></SPAN></P></BODY></HTML> Mon, 09 May 2016 12:45:45 GMT https://community.qlik.com/t5/Espa%C3%B1ol/PROBLEMAS-CON-SET-ANALYSIS-Y-RGB/m-p/1032948#M10137 jolivares 2016-05-09T12:45:45Z