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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2009-10-08 02:15 PM

Maximum aggregation Value

Hi all!

I'd like to dynamically change the scale of my axis by using the max min Values in the Axis Tab.

I think it would be the best to get the max of an aggregated Value.What I want to do is something like


max(aggr(sum(Sales), Month))


to get the highest Sales Value of an Month!!

Unfortunatly that doesn't work! Any Ideas?

Greetings

andi

2,232 Views
0 Likes
10 Replies
Not applicable
‎2009-10-08 06:50 PM
Author

In response to

In your excel example a couple posts up, you show a row consisting of the max value repeated over all months. Are you trying to show what Sales would have been if all months were the max value? If so, your formula would have to look like this:

=Sum(aggr(Max(Total aggr(Sum(Sales), Month)), Month))

115 Views