Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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 

Labels (1)
1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

Re: some doubts about AGGR()

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