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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Ranked table averages in comparison

Hi,

I have countries and sales amounts (per sales representative) and showing a table for top 25 salesman in each specific country and then take averages of it. I am using straight table.

Dimensions:

     Region

     Salesrep Name

Expression:

     =IF(AGGR(RANK (Total(sum(sales))),[Salesrep Name])<=25,sum(sales ))

I also displayed the averages at the last row at above mentioned straight table.

Now, I would like to use this (only top 25 salesmen's) average and compare it with individual salesman performance using line charts.

What would be the best way you recommend? When I wanted to use the above expression in the chart; it is trying to bring in whole chunk of records. I want it (averages only) to be represented with 1 single line which will be used to compare individual sales person's performance.

Any ideas? Thanks in advance.

Best regards,

piroglu1907

0 Replies