topic Help with Partial sum in pivot table in QlikView https://community.qlik.com/t5/QlikView/Help-with-Partial-sum-in-pivot-table/m-p/311747#M1197730 <HTML><HEAD></HEAD><BODY><P>Hi All, I am using</P><P>=If(ISNULL(End_Month_Yr) AND [Start_Month_Yr] &lt;= [Month_Yr], Sum(Amt), if([End_Month_Yr] &gt;= [Month_Yr], Sum(Amt), 0))</P><P>as pivot chart expression. But the Total ( partial sum) populating zeros, why its not populating the Total?</P><P></P><P>Please Help. Thanks in Advance.</P><P></P></BODY></HTML> Tue, 08 Mar 2011 20:32:37 GMT 2011-03-08T20:32:37Z Help with Partial sum in pivot table https://community.qlik.com/t5/QlikView/Help-with-Partial-sum-in-pivot-table/m-p/311747#M1197730 <HTML><HEAD></HEAD><BODY><P>Hi All, I am using</P><P>=If(ISNULL(End_Month_Yr) AND [Start_Month_Yr] &lt;= [Month_Yr], Sum(Amt), if([End_Month_Yr] &gt;= [Month_Yr], Sum(Amt), 0))</P><P>as pivot chart expression. But the Total ( partial sum) populating zeros, why its not populating the Total?</P><P></P><P>Please Help. Thanks in Advance.</P><P></P></BODY></HTML> Tue, 08 Mar 2011 20:32:37 GMT https://community.qlik.com/t5/QlikView/Help-with-Partial-sum-in-pivot-table/m-p/311747#M1197730 2011-03-08T20:32:37Z Help with Partial sum in pivot table https://community.qlik.com/t5/QlikView/Help-with-Partial-sum-in-pivot-table/m-p/311748#M1197731 <HTML><HEAD></HEAD><BODY><P>I got it...</P><P>Changed my expression as</P><P>=Sum(If(ISNULL(End_Month_Yr) AND [Start_Month_Yr] &lt;= [Month_Yr], Amt, if([End_Month_Yr] &gt;= [Month_Yr], Amt, 0)))</P></BODY></HTML> Tue, 08 Mar 2011 20:40:40 GMT https://community.qlik.com/t5/QlikView/Help-with-Partial-sum-in-pivot-table/m-p/311748#M1197731 2011-03-08T20:40:40Z