Nested aggregation not allowed :(

[DK3]

I have a large dataset with Locations, Parameters and Values. Need to visualize (in a Treemap or otherwise) the highest Counts of Values above their 95 percentile, by Parameter and Location. 

Wondering how to write an expression combining (if(Value>fractile(Value, 0.95), Value) and Count(Value) without running into the nested aggregation error. 

Fresh baby in the Qlik community, please bear with me. 

[Or]

Aggr() will become your new best friend...

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/aggr.htm

[DK3]

Thanks! Tried count(aggr(if(Value>fractile(Value, 0.95),Value),Parameter, Location)) but it returns zeros... 

Might you able to help me understand why?

[Or · Accepted solution]

I am unsure what your data model is, what your object definitions are, etc. I don't see anything wrong with the syntax. Is the inner if() statement working on its own when used in an object, e.g. a table? Are these two fields what you actually need to aggr() by?

Potentially useful reading:

https://community.qlik.com/t5/Design/AGGR/ba-p/1475149