Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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