Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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