Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lampshadedreams
Contributor III
Contributor III

AGGR in Chart, Filter should not change Chart

Hi, 

I have the following aggregate expression that sums the budget by ProjID & Month:

=sum(aggr(sum(DISTINCT[Budget]), [ProjID],Month))

This works beautifully in my chart, however, I would like to prevent the Month filter from changing the chart.

My chart has Sum of Budget in Y axis and Month in X axis. I tried doing this but it didn't work:

=sum(aggr(sum(DISTINCT {<Month=>}[Budget]), [ProjID],Month))

 

1 Solution

Accepted Solutions
sunny_talwar

Try adding Month to the outer sum's set expression as well

=Sum({<Month=>} Aggr(Sum(DISTINCT {<Month=>} [Budget]), [ProjID], Month))

View solution in original post

3 Replies
sunny_talwar

Try adding Month to the outer sum's set expression as well

=Sum({<Month=>} Aggr(Sum(DISTINCT {<Month=>} [Budget]), [ProjID], Month))
lampshadedreams
Contributor III
Contributor III
Author

That worked great, thanks so much Sunny!

Note: There is an error on this website when I try to accept the solution. I keep getting: The page you are trying to access was not found. Please check your URL for typos and try again.

sunny_talwar

Happy to help 🙂