topic using aggr with an if statement in QlikView

topic using aggr with an if statement in QlikView https://community.qlik.com/t5/QlikView/using-aggr-with-an-if-statement/m-p/353936#M1176913 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm trying to create a subtotal uisng an if statement</P><P></P><P>Sample Data</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 417px;"><TBODY><TR><TD class="xl79" height="21" width="123"><STRONG>Products</STRONG></TD><TD class="xl65" style="border-left: medium none;" width="98"><STRONG>Rejected</STRONG></TD><TD class="xl66" width="98"><STRONG>Count</STRONG></TD><TD class="xl66" style="border-left: medium none;" width="98"></TD></TR><TR><TD class="xl80" height="21" style="border-top: medium none;"><STRONG>Total</STRONG></TD><TD class="xl67" style="border-top: medium none;"><STRONG> </STRONG></TD><TD class="xl68" style="border-left: medium none; border-top: medium none;"><STRONG>6,458</STRONG></TD><TD class="xl69" style="border-left: medium none; border-top: medium none;"></TD></TR><TR><TD class="xl81" height="20" style="border-top: medium none;">Product 1</TD><TD class="xl66" style="border-left: medium none; border-top: medium none;">0</TD><TD class="xl70" style="border-left: medium none; border-top: medium none;">2,000</TD><TD class="xl71" style="border-left: medium none; border-top: medium none;"></TD></TR><TR><TD class="xl81" height="20" style="border-top: medium none;">Product 2</TD><TD class="xl66" style="border-left: medium none; border-top: medium none;">1</TD><TD class="xl70" style="border-left: medium none; border-top: medium none;">2,592</TD><TD class="xl71" style="border-left: medium none; border-top: medium none;"></TD></TR><TR><TD class="xl81" height="20" style="border-top: medium none;">Product 3</TD><TD class="xl66" style="border-left: medium none; border-top: medium none;">2</TD><TD class="xl70" style="border-left: medium none; border-top: medium none;">1,866</TD><TD class="xl71" style="border-left: medium none; border-top: medium none;"></TD></TR><TR><TD class="xl81" height="20" style="border-top: medium none;"><P></P><P><STRONG>Solution required</STRONG></P></TD><TD class="xl66" style="border-left: medium none; border-top: medium none;"></TD><TD class="xl70" style="border-left: medium none; border-top: medium none;"></TD><TD class="xl71" style="border-left: medium none; border-top: medium none;">%</TD></TR><TR><TD class="xl83" height="20">Product 1</TD><TD class="xl72">0</TD><TD class="xl74">2,000</TD><TD class="xl75">31%</TD></TR><TR><TD class="xl84" height="20">Products 1 to 2</TD><TD class="xl74"></TD><TD class="xl76">4,458</TD><TD>69%</TD></TR><TR><TD class="xl85" colspan="2" height="21"><STRONG>For Selected Dimensions</STRONG></TD><TD class="xl77"><STRONG>6,458</STRONG></TD><TD class="xl78"><STRONG>100%</STRONG></TD></TR></TBODY></TABLE><P></P><P>So, I need to add Products 1 to 2 toghether and express it as a % of the totlal of each dimension a user selects.</P><P></P><P>Thanks in advance.</P><P></P><P>Brian</P></BODY></HTML> Thu, 15 Mar 2012 09:58:26 GMT 2012-03-15T09:58:26Z using aggr with an if statement https://community.qlik.com/t5/QlikView/using-aggr-with-an-if-statement/m-p/353936#M1176913 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm trying to create a subtotal uisng an if statement</P><P></P><P>Sample Data</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 417px;"><TBODY><TR><TD class="xl79" height="21" width="123"><STRONG>Products</STRONG></TD><TD class="xl65" style="border-left: medium none;" width="98"><STRONG>Rejected</STRONG></TD><TD class="xl66" width="98"><STRONG>Count</STRONG></TD><TD class="xl66" style="border-left: medium none;" width="98"></TD></TR><TR><TD class="xl80" height="21" style="border-top: medium none;"><STRONG>Total</STRONG></TD><TD class="xl67" style="border-top: medium none;"><STRONG> </STRONG></TD><TD class="xl68" style="border-left: medium none; border-top: medium none;"><STRONG>6,458</STRONG></TD><TD class="xl69" style="border-left: medium none; border-top: medium none;"></TD></TR><TR><TD class="xl81" height="20" style="border-top: medium none;">Product 1</TD><TD class="xl66" style="border-left: medium none; border-top: medium none;">0</TD><TD class="xl70" style="border-left: medium none; border-top: medium none;">2,000</TD><TD class="xl71" style="border-left: medium none; border-top: medium none;"></TD></TR><TR><TD class="xl81" height="20" style="border-top: medium none;">Product 2</TD><TD class="xl66" style="border-left: medium none; border-top: medium none;">1</TD><TD class="xl70" style="border-left: medium none; border-top: medium none;">2,592</TD><TD class="xl71" style="border-left: medium none; border-top: medium none;"></TD></TR><TR><TD class="xl81" height="20" style="border-top: medium none;">Product 3</TD><TD class="xl66" style="border-left: medium none; border-top: medium none;">2</TD><TD class="xl70" style="border-left: medium none; border-top: medium none;">1,866</TD><TD class="xl71" style="border-left: medium none; border-top: medium none;"></TD></TR><TR><TD class="xl81" height="20" style="border-top: medium none;"><P></P><P><STRONG>Solution required</STRONG></P></TD><TD class="xl66" style="border-left: medium none; border-top: medium none;"></TD><TD class="xl70" style="border-left: medium none; border-top: medium none;"></TD><TD class="xl71" style="border-left: medium none; border-top: medium none;">%</TD></TR><TR><TD class="xl83" height="20">Product 1</TD><TD class="xl72">0</TD><TD class="xl74">2,000</TD><TD class="xl75">31%</TD></TR><TR><TD class="xl84" height="20">Products 1 to 2</TD><TD class="xl74"></TD><TD class="xl76">4,458</TD><TD>69%</TD></TR><TR><TD class="xl85" colspan="2" height="21"><STRONG>For Selected Dimensions</STRONG></TD><TD class="xl77"><STRONG>6,458</STRONG></TD><TD class="xl78"><STRONG>100%</STRONG></TD></TR></TBODY></TABLE><P></P><P>So, I need to add Products 1 to 2 toghether and express it as a % of the totlal of each dimension a user selects.</P><P></P><P>Thanks in advance.</P><P></P><P>Brian</P></BODY></HTML> Thu, 15 Mar 2012 09:58:26 GMT https://community.qlik.com/t5/QlikView/using-aggr-with-an-if-statement/m-p/353936#M1176913 2012-03-15T09:58:26Z