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

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?

Thanks in advance.

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

its_anandrjs
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

SunilChauhan
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 ))

its_anandrjs
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

SunilChauhan
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.

its_anandrjs
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