# New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Not applicable

## Can I show Top 25 salesman with detached display using set analysis?

Hi,

I have countries and sales amounts (per sales representative) and would like to show 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 ))

However, my expression is selection dependant. I would like to detach it permanently so that we will always see top 25 sales rep in each country.

To be able to do that; I was trying to change my expression into:

=IF(AGGR(RANK (Total(sum({1<REGION={Singapore}>}sales))),[Salesrep Name])<=25,sum({1<REGION={Singapore}>}sales))

However, it is still selection dependant. (if I choose other countries from listbox, this table does not bring any figures). Would you have any suggestions?

Best regards,

piroglu1907

6 Replies
Not applicable

## Can I show Top 25 salesman with detached display using set analysis?

Hi,

I think you have to use some thing like this .

Dimension:

[Salesrep Name])

In the expression you give   =sum({1} sales)

Sort by Descending order of the expression .

In the Presentation tab give Max Number as 25

Rgds

DS

Not applicable

## Can I show Top 25 salesman with detached display using set analysis?

Hi,

Can you share any sample file for that.

Rgds

Anand

Not applicable

## Can I show Top 25 salesman with detached display using set analysis?

try this

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

Not applicable

## Re: Can I show Top 25 salesman with detached display using set analysis?

Hi Sunil,

What is meaning of {1} in your code could you explain it why using it two times.

Rgds

Anand

Not applicable

## Can I show Top 25 salesman with detached display using set analysis?

Good question anandi

{1}-. used for all and not to select any thingthat is like deatttach.

where ever you write sum or aggr function it need to put {1} in order to create deattach functionality.

Anand,if you have question then make a seperate post so that people should not distract.

Not applicable

## Re: Can I show Top 25 salesman with detached display using set analysis?

Hi,

I could not understand it what you explained, Do you have any sample to explain it if so thanks for you in advance.

Let me know its not urgent yet.

Better if you explain it in example.

Rgds

Anand

Community Browser