Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Rizzo
Contributor II
Contributor II

Sum MAX values in set analysis

Hi All,

There are such data:

ID CITY NUMBER
1 London 5
2 London 8
3 Berlin 3
4 Rome 6
5 Berlin 7
6 Warsaw 8
7 Rome 1
8 Warsaw 5

I need to sum only max numbers of the cities and show the result in KPI chart.
The math is like this:
London(8) + Berlin(7) + Rome(6) + Warsaw(8) = 29

How should look the expresion ?

Labels (1)
1 Solution

Accepted Solutions
tamilarasu

Try,

Sum(Aggr(Max(NUMBER), CITY))

View solution in original post

1 Reply
tamilarasu

Try,

Sum(Aggr(Max(NUMBER), CITY))

View solution in original post