https://community.qlik.com/t5/QlikView/different-conditions/m-p/450882#M168271 <HTML><HEAD></HEAD><BODY><P>Hi! thank you for help.&nbsp; result stil not for each row:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="422"><TBODY><TR><TD class="xl65" height="125" width="98">country</TD><TD class="xl65" style="border-left: medium none;" width="98">mes_a</TD><TD class="xl68" style="border-left: medium none;" width="112">sum( if(aggr(sum({&lt;bg_t={'*'} &gt;}Quantity),AffiliateID,Holding,mes,mes_a )&gt;0 <BR /> and mes = mes_a<BR /> ,1,0))</TD><TD class="xl68" style="border-left: medium none;" width="114">sum(if(aggr(sum({&lt;bg_t={'*'}, mes = p(mes_a) &gt;}Quantity),AffiliateID,Holding,mes,mes_a )&gt;0 ,1,0))</TD></TR><TR><TD class="xl67" height="17" style="border-top: medium none;">England</TD><TD class="xl66" style="border-top: medium none; border-left: medium none;">201201</TD><TD class="xl66" style="border-top: medium none; border-left: medium none;">313</TD><TD class="xl66" style="border-top: medium none; border-left: medium none;">1004</TD></TR><TR><TD class="xl67" height="17" style="border-top: medium none;">England</TD><TD class="xl66" style="border-top: medium none; border-left: medium none;">201202</TD><TD class="xl66" style="border-top: medium none; border-left: medium none;">328</TD><TD class="xl66" style="border-top: medium none; border-left: medium none;">1004</TD></TR><TR><TD class="xl67" height="17" style="border-top: medium none;">England</TD><TD class="xl66" style="border-top: medium none; border-left: medium none;">201203</TD><TD class="xl66" style="border-top: medium none; border-left: medium none;">363</TD><TD class="xl66" style="border-top: medium none; border-left: medium none;">1004</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 19 Dec 2012 11:23:57 GMT 2012-12-19T11:23:57Z https://community.qlik.com/t5/QlikView/different-conditions/m-p/450880#M168269 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>is anyone know </P><P></P><P>in theory ...why it't the same?</P><P></P><P><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">sum</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">( </SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">if</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">aggr</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">sum</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">({&lt;</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">bg_t</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">={'*'}</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> &gt;}Quantity),AffiliateID,Holding,mes,mes_a )&gt;0 <BR /> <STRONG>and </STRONG></SPAN><STRONG><SPAN lang="EN-US" style="font-size: 14pt; font-family: 'Courier New'; color: black;">mes = mes_a</SPAN></STRONG><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /> ,1,0)) </SPAN></P><P><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">works<BR /></SPAN></P><P></P><P></P><P></P><P><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">sum</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">if</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">aggr</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">sum</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">({&lt;</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">bg_t</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">={'*'}</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">}, </SPAN><STRONG><SPAN lang="EN-US" style="font-size: 14.0pt; font-family: 'Courier New'; color: black;">mes = mes_a</SPAN></STRONG><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> &gt;}Quantity),AffiliateID,Holding,mes,mes_a )&gt;0 ,1,0)) </SPAN></P><P><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">not works</SPAN></P></BODY></HTML> Wed, 19 Dec 2012 09:53:21 GMT https://community.qlik.com/t5/QlikView/different-conditions/m-p/450880#M168269 2012-12-19T09:53:21Z https://community.qlik.com/t5/QlikView/different-conditions/m-p/450881#M168270 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Try this expression</P><P></P><P><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">sum</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">if</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">aggr</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">sum</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">({&lt;</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">bg_t</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">={'*'}</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">}, </SPAN><STRONG><SPAN lang="EN-US" style="font-size: 14.0pt; font-family: 'Courier New'; color: black;">mes = p(mes_a)</SPAN></STRONG><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> &gt;}Quantity),AffiliateID,Holding,mes,mes_a )&gt;0 ,1,0)) </SPAN></P></BODY></HTML> Wed, 19 Dec 2012 10:00:08 GMT https://community.qlik.com/t5/QlikView/different-conditions/m-p/450881#M168270 perumal_41 2012-12-19T10:00:08Z https://community.qlik.com/t5/QlikView/different-conditions/m-p/450882#M168271 <HTML><HEAD></HEAD><BODY><P>Hi! thank you for help.&nbsp; result stil not for each row:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="422"><TBODY><TR><TD class="xl65" height="125" width="98">country</TD><TD class="xl65" style="border-left: medium none;" width="98">mes_a</TD><TD class="xl68" style="border-left: medium none;" width="112">sum( if(aggr(sum({&lt;bg_t={'*'} &gt;}Quantity),AffiliateID,Holding,mes,mes_a )&gt;0 <BR /> and mes = mes_a<BR /> ,1,0))</TD><TD class="xl68" style="border-left: medium none;" width="114">sum(if(aggr(sum({&lt;bg_t={'*'}, mes = p(mes_a) &gt;}Quantity),AffiliateID,Holding,mes,mes_a )&gt;0 ,1,0))</TD></TR><TR><TD class="xl67" height="17" style="border-top: medium none;">England</TD><TD class="xl66" style="border-top: medium none; border-left: medium none;">201201</TD><TD class="xl66" style="border-top: medium none; border-left: medium none;">313</TD><TD class="xl66" style="border-top: medium none; border-left: medium none;">1004</TD></TR><TR><TD class="xl67" height="17" style="border-top: medium none;">England</TD><TD class="xl66" style="border-top: medium none; border-left: medium none;">201202</TD><TD class="xl66" style="border-top: medium none; border-left: medium none;">328</TD><TD class="xl66" style="border-top: medium none; border-left: medium none;">1004</TD></TR><TR><TD class="xl67" height="17" style="border-top: medium none;">England</TD><TD class="xl66" style="border-top: medium none; border-left: medium none;">201203</TD><TD class="xl66" style="border-top: medium none; border-left: medium none;">363</TD><TD class="xl66" style="border-top: medium none; border-left: medium none;">1004</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 19 Dec 2012 11:23:57 GMT https://community.qlik.com/t5/QlikView/different-conditions/m-p/450882#M168271 2012-12-19T11:23:57Z