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.
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?
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?
