topic Re: Advanced AGGR with Nested If in QlikView https://community.qlik.com/t5/QlikView/Advanced-AGGR-with-Nested-If/m-p/327938#M120758 <HTML><HEAD></HEAD><BODY><P>I'd expect you to be able to use just about any expression in an aggr to get a column total.&nbsp; The general form is this:</P><P></P><P style="padding-left: 30px;"><SPAN style="font-family: courier new,courier;">sum(aggr(YourCurrentExpression,YourFirstDimension,YourSecondDimension,etc))</SPAN></P></BODY></HTML> Wed, 25 May 2011 23:04:52 GMT johnw 2011-05-25T23:04:52Z Advanced AGGR with Nested If https://community.qlik.com/t5/QlikView/Advanced-AGGR-with-Nested-If/m-p/327937#M120757 <HTML><HEAD></HEAD><BODY><P>The below expression at the line level returns the desired outcome. Unfortunately when used in the pivot table the column totals are incorrect. Is there a way to use an if statement like below in the AGGR expression?</P><P></P><P>=if((not isnull(Order__c.Ship_Date__c)) and Booked_on_AS400_a&nbsp; &lt;&gt;'' and Rev_Rec_a &gt; Today(),sum(Total_Price_a))</P><P></P><P>Thanx</P></BODY></HTML> Wed, 25 May 2011 18:06:45 GMT https://community.qlik.com/t5/QlikView/Advanced-AGGR-with-Nested-If/m-p/327937#M120757 2011-05-25T18:06:45Z Re: Advanced AGGR with Nested If https://community.qlik.com/t5/QlikView/Advanced-AGGR-with-Nested-If/m-p/327938#M120758 <HTML><HEAD></HEAD><BODY><P>I'd expect you to be able to use just about any expression in an aggr to get a column total.&nbsp; The general form is this:</P><P></P><P style="padding-left: 30px;"><SPAN style="font-family: courier new,courier;">sum(aggr(YourCurrentExpression,YourFirstDimension,YourSecondDimension,etc))</SPAN></P></BODY></HTML> Wed, 25 May 2011 23:04:52 GMT https://community.qlik.com/t5/QlikView/Advanced-AGGR-with-Nested-If/m-p/327938#M120758 johnw 2011-05-25T23:04:52Z