Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
DK3
New Member
New Member

Nested aggregation not allowed :(

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. 

Labels (2)
3 Replies
DK3
New Member
New Member
Author

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
MVP
MVP

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