topic Re: if condition on aggr in QlikView https://community.qlik.com/t5/QlikView/if-condition-on-aggr/m-p/1209715#M388235 <HTML><HEAD></HEAD><BODY><P>Do you mean invoice having USD&gt;0?</P></BODY></HTML> Fri, 21 Oct 2016 09:32:16 GMT shraddha_g 2016-10-21T09:32:16Z if condition on aggr https://community.qlik.com/t5/QlikView/if-condition-on-aggr/m-p/1209714#M388234 <HTML><HEAD></HEAD><BODY><P>Hi, i need to calculate, sum(quantity) only for invoice &gt;0<SPAN style="font-size: 10pt; line-height: 1.5em;">&nbsp; in a box</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="147"><TBODY><TR><TD class="xl63" height="17" width="49">Invoice</TD><TD class="xl63" style="border-left: none;" width="55">quantity</TD><TD class="xl63" style="border-left: none;" width="43">USD</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">a</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">22</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20,99</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">b</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">8</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">c</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">5</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">d</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">e</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">5</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">f</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">43</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">69</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">g</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">38</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">37,95</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">h</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">16</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">i</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">86</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">10,9</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">l</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">38</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">158,19</TD></TR></TBODY></TABLE><P>Thanks</P></BODY></HTML> Fri, 21 Oct 2016 09:30:08 GMT https://community.qlik.com/t5/QlikView/if-condition-on-aggr/m-p/1209714#M388234 canmarroig 2016-10-21T09:30:08Z Re: if condition on aggr https://community.qlik.com/t5/QlikView/if-condition-on-aggr/m-p/1209715#M388235 <HTML><HEAD></HEAD><BODY><P>Do you mean invoice having USD&gt;0?</P></BODY></HTML> Fri, 21 Oct 2016 09:32:16 GMT https://community.qlik.com/t5/QlikView/if-condition-on-aggr/m-p/1209715#M388235 shraddha_g 2016-10-21T09:32:16Z Re: if condition on aggr https://community.qlik.com/t5/QlikView/if-condition-on-aggr/m-p/1209716#M388236 <HTML><HEAD></HEAD><BODY><P>Yess, </P></BODY></HTML> Fri, 21 Oct 2016 09:34:12 GMT https://community.qlik.com/t5/QlikView/if-condition-on-aggr/m-p/1209716#M388236 canmarroig 2016-10-21T09:34:12Z Re: if condition on aggr https://community.qlik.com/t5/QlikView/if-condition-on-aggr/m-p/1209717#M388237 <HTML><HEAD></HEAD><BODY><P>Try:</P><P></P><P>sum({&lt;USD = {"&gt;0"}&gt;}quantity)</P></BODY></HTML> Fri, 21 Oct 2016 09:41:16 GMT https://community.qlik.com/t5/QlikView/if-condition-on-aggr/m-p/1209717#M388237 shraddha_g 2016-10-21T09:41:16Z