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: 
micheledenardi
Specialist II
Specialist II

Get Max Sales over all countries

Hi experts,

without using variables, i would like to calculate a new column on my strainght table where to put the max sales value over all countries:

With this data USA has the maximum number of Sales (12), i would like to create the column in blue where i have the max sales number over all countries. 

CountrySum(Sales)Max Sales
Spain 212
Germany 612
Italy912
USA1212
Mexico712
Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

Try this

Max(TOTAL Aggr(
    Sum(Sales)
, Country))

View solution in original post

4 Replies
mfarsln
Creator II
Creator II

Hi,

Try this;

max(total Sales)
sunny_talwar

Try this

Max(TOTAL Aggr(
    Sum(Sales)
, Country))
micheledenardi
Specialist II
Specialist II
Author

Won't work.

Your solution show only the maximum value of Sales not the max value aggregated by country

2020-03-03 15_16_57-QlikView x64 - Copia del rivenditore - [C__Users_denardm2_Desktop_temp.qvw_].png

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
Sergio3
Partner - Contributor III
Partner - Contributor III

Hi!

U need use AGGR ( like GROUP BY 😞