Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Sept. 16, Qlik Product Portfolio Strategy and Roadmap for Data Integration 11 AM ET REGISTER 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))

View solution in original post

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 🙂