topic aggr with two conditions in QlikView https://community.qlik.com/t5/QlikView/aggr-with-two-conditions/m-p/353050#M1174075 <HTML><HEAD></HEAD><BODY><P>I think its possible... try to put the variable in a text object to check if the format is different.</P></BODY></HTML> Wed, 16 May 2012 17:58:10 GMT cesaraccardi 2012-05-16T17:58:10Z aggr with two conditions https://community.qlik.com/t5/QlikView/aggr-with-two-conditions/m-p/353047#M1174069 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; i will be pleased if someone could help me with this expression:</P><P></P><P><STRONG>sum(Aggr(if(count(DEAL_EXTERNALS.deal_externals_id) &gt; 1 and USERS.user_created = Mes_AntAnterior,1,0),USERS.email))</STRONG></P><P></P><P>up to here:</P><P><STRONG>sum(Aggr(if(count(DEAL_EXTERNALS.deal_externals_id) &gt; 1 ,1,0),USERS.email))</STRONG> the values are ok but,</P><P></P><P> when i add the second condition "<STRONG>and USERS.user_created = Mes_AntAnterior</STRONG>" the values get wrong.</P><P></P><P>Below the definitions of both:</P><P><STRONG>Mes_AntAnterior</STRONG>= month(addmonths(today(),-2)) &amp; '-' &amp; year(addmonths(today(),-2))</P><P><STRONG>USERS.user_created</STRONG> = month(today()) &amp; '-' &amp; year(today())</P><P></P><P></P><P><SPAN style="color: #333333; text-decoration: underline;">workaround:</SPAN></P><P><STRONG>sum(Aggr(if(count(DEAL_EXTERNALS.deal_externals_id) &gt; 1 and USERS.created &gt;= Today()-60,1,0),USERS.email))</STRONG></P><P>where <STRONG>USERS.created</STRONG> has this kind of format 40493, 40494, 40497.....</P><P></P><P>i think the problem is with the definitions of Mes_AntAnterior and USERS.user_created. How can i change this definitions to solve the issue.</P><P></P><P>thanks.</P><P>gerardo</P></BODY></HTML> Tue, 15 May 2012 18:32:15 GMT https://community.qlik.com/t5/QlikView/aggr-with-two-conditions/m-p/353047#M1174069 2012-05-15T18:32:15Z aggr with two conditions https://community.qlik.com/t5/QlikView/aggr-with-two-conditions/m-p/353048#M1174071 <HTML><HEAD></HEAD><BODY><P> Hi gerardo, you can change the variable type in Document Properties dialog =&gt; Number sheet.</P></BODY></HTML> Tue, 15 May 2012 20:59:32 GMT https://community.qlik.com/t5/QlikView/aggr-with-two-conditions/m-p/353048#M1174071 cesaraccardi 2012-05-15T20:59:32Z aggr with two conditions https://community.qlik.com/t5/QlikView/aggr-with-two-conditions/m-p/353049#M1174073 <HTML><HEAD></HEAD><BODY><P>Hi Cesar,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; do you think because of that i couldn't compare this: <STRONG>USERS.user_created = Mes_AntAnterior?</STRONG></P><P></P><P>thanks </P><P>Gerardo</P></BODY></HTML> Wed, 16 May 2012 12:05:08 GMT https://community.qlik.com/t5/QlikView/aggr-with-two-conditions/m-p/353049#M1174073 2012-05-16T12:05:08Z aggr with two conditions https://community.qlik.com/t5/QlikView/aggr-with-two-conditions/m-p/353050#M1174075 <HTML><HEAD></HEAD><BODY><P>I think its possible... try to put the variable in a text object to check if the format is different.</P></BODY></HTML> Wed, 16 May 2012 17:58:10 GMT https://community.qlik.com/t5/QlikView/aggr-with-two-conditions/m-p/353050#M1174075 cesaraccardi 2012-05-16T17:58:10Z aggr with two conditions https://community.qlik.com/t5/QlikView/aggr-with-two-conditions/m-p/353051#M1174078 <HTML><HEAD></HEAD><BODY><P>Hi Gerar! </P><P></P><P>Mes_AntAnterior es un campo o una variable?</P><P></P><P>Si es un campo y no está en la misma tabla que USERS.user_created muchas veces es causa de que un Sum(If... no funcione.</P><P></P><P>Si es una variable (cosa que creo que es lo más lógico que sea), usá $(Mes_AntAnterior) en lugar de Mes_AntAnterior.</P><P></P><P>Por otro lado, como más importante, es qué formato tienen cada uno. Cuando indicás las definiciones en tu consulta los dos dependen de Today(), ninguno de un dato de campo... Dónde los definís? en el script (con let??) o en el panel de variables?? Disculpá mi falta de comprensión.</P></BODY></HTML> Thu, 17 May 2012 16:56:24 GMT https://community.qlik.com/t5/QlikView/aggr-with-two-conditions/m-p/353051#M1174078 sebastiandperei 2012-05-17T16:56:24Z aggr with two conditions https://community.qlik.com/t5/QlikView/aggr-with-two-conditions/m-p/353052#M1174080 <HTML><HEAD></HEAD><BODY><P>Hola Sebastian! gracias por la respuesta...</P><P></P><P> estoy definiendo <STRONG>Mes_AntAnterior </STRONG>en el script con let, no asi el <STRONG>USERS.user_created que es el dato de un campo.</STRONG></P><P></P><P><STRONG>Voy a probar lo que me decis a ver que onda....</STRONG></P><P></P><P><STRONG>saludos!<BR /></STRONG></P></BODY></HTML> Thu, 17 May 2012 17:38:00 GMT https://community.qlik.com/t5/QlikView/aggr-with-two-conditions/m-p/353052#M1174080 2012-05-17T17:38:00Z aggr with two conditions https://community.qlik.com/t5/QlikView/aggr-with-two-conditions/m-p/353053#M1174082 <HTML><HEAD></HEAD><BODY><P>Entonces Mes_AntAnterior es una variable. Si hacés un cuadro de texto con =Mes_AntAnterior, qué te muestra?</P><P></P><P>Por otro lado, te recomiendo sum en lugar de count... va más rápido</P></BODY></HTML> Fri, 18 May 2012 17:54:57 GMT https://community.qlik.com/t5/QlikView/aggr-with-two-conditions/m-p/353053#M1174082 sebastiandperei 2012-05-18T17:54:57Z aggr with two conditions https://community.qlik.com/t5/QlikView/aggr-with-two-conditions/m-p/353054#M1174083 <HTML><HEAD></HEAD><BODY><P>Y? Funcionó?</P></BODY></HTML> Mon, 21 May 2012 01:34:09 GMT https://community.qlik.com/t5/QlikView/aggr-with-two-conditions/m-p/353054#M1174083 sebastiandperei 2012-05-21T01:34:09Z Re: aggr with two conditions https://community.qlik.com/t5/QlikView/aggr-with-two-conditions/m-p/353055#M1174084 <HTML><HEAD></HEAD><BODY><P>Hola Sebastian! Perdón por no contestar antes. No pude probarlo todavía, estoy con unos quilombos en el servidor de correo que no me deja avanzar con qlikview.</P><P></P><P> </P><P></P><P>De: Sebastian Pereira <A href="mailto:qliktech@sgaur.hosted.jivesoftware.com"></A> </P><P>Enviado el: domingo, 20 de mayo de 2012 10:34 p.m.</P><P>Para: Pauza, Gerardo</P><P>Asunto: <A href="New to QlikView"></A> - Re: aggr with two conditions</P><P></P><P> </P><P></P><P></P><P>QlikCommunity &lt;http://community.qlik.com/index.jspa&gt; </P><P></P><P></P><P>Re: aggr with two conditions </P><P></P><P></P><P>created by Sebastian Pereira &lt;http://community.qlik.com/people/sebastiandpereira&gt; in New to QlikView - View the full discussion &lt;http://community.qlik.com/message/221057#221057</P></BODY></HTML> Wed, 23 May 2012 13:13:32 GMT https://community.qlik.com/t5/QlikView/aggr-with-two-conditions/m-p/353055#M1174084 2012-05-23T13:13:32Z Re: aggr with two conditions https://community.qlik.com/t5/QlikView/aggr-with-two-conditions/m-p/353056#M1174085 <HTML><HEAD></HEAD><BODY><P>Cómo van esos temas Gerar?</P></BODY></HTML> Wed, 20 Jun 2012 02:55:22 GMT https://community.qlik.com/t5/QlikView/aggr-with-two-conditions/m-p/353056#M1174085 sebastiandperei 2012-06-20T02:55:22Z