Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
LAlvarado
Partner - Contributor
Partner - Contributor

some doubts about AGGR()

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

 

 

Thank you 

1 Reply
marcus_sommer

You might not need an aggr(). Take a look on the following links:

Use Aggregation Functions!

AGGR...

When should the Aggr() function NOT be used?

Pitfalls-of-the-Aggr-function

- Marcus