Discussion Board for collaboration on QlikView Layout & Visualizations.
I would like to calculate the maximum value of a group of rows in a straight table and use it for every particular row to calculate ratios.
As an example please see table below. The last column should display the maximum value for each country, i.e. 35 for the first three rows, 57 for the next three etc.
=Aggr(Max(Aggr(Sum(Units), Country, Product)), Country),
but unfortunately as it shows in the picture this only gives values for the lines with ‘Apple’ and NULL for the others L
Try the total syntax
Max( total <Country> Aggr( Sum(Units), Country,Product) )
This will add up the units for each combination of country and product, and then take the max value for each country and display it
View solution in original post
max(TOTAL <Country> aggr(sum(Units),Country,Product))
Thank you very much, that works!