Discussion board where members can get started with Qlik Sense.
Hi everyone, there are some problems I'm facing when using the AGGR function and I have some questions
for this I need to know if any (of all) of these things can be done
1) use an AGGR to sort one measure in descending order (on a stacked bar chart with 1 dimmension - 2 measures)
2) how to include 2 dimensions in an AGGR function when I'm only using one in the chart
3) how to obtain the top 80% from a field value
You might not need an aggr(). Take a look on the following links:
Use Aggregation Functions!
When should the Aggr() function NOT be used?