Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with Partial sum in pivot table

Hi All, I am using

=If(ISNULL(End_Month_Yr) AND [Start_Month_Yr] <= [Month_Yr], Sum(Amt), if([End_Month_Yr] >= [Month_Yr], Sum(Amt), 0))

as pivot chart expression. But the Total ( partial sum) populating zeros, why its not populating the Total?

Please Help. Thanks in Advance.

1 Solution

Accepted Solutions
Not applicable
Author

I got it...

Changed my expression as

=Sum(If(ISNULL(End_Month_Yr) AND [Start_Month_Yr] <= [Month_Yr], Amt, if([End_Month_Yr] >= [Month_Yr], Amt, 0)))

View solution in original post

1 Reply
Not applicable
Author

I got it...

Changed my expression as

=Sum(If(ISNULL(End_Month_Yr) AND [Start_Month_Yr] <= [Month_Yr], Amt, if([End_Month_Yr] >= [Month_Yr], Amt, 0)))