Max value per semester

[lessassy]

Hello everyone,

I have a straigh table 

I woul like to use a set analysis to get the maximum value per Quarter (= Trimestrein french).

FOr instance in the first quarter the max value is 270 and i would like to display it using a set analysis.

Thanks in advance

[Fernando_Fabregas]

Hi !

Did you try using TOTAL qualifier? 

Max(TOTAL <Year,Trimester> Value)

Here is the full explanation: 

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/define-ag...

Regards, Fernando

[lorenzoconforti]

Aggregation might help:

sum(aggr(nodistinct FirstSortedValue(VALUE, -aggr(sum(VALUE), MONTH),1), TRIMESTER))