qlik scenario

[siva8]

Hi All,

i have a scenario like below can u please help us 

any  chart(ex : bar ) should show top 5 and bottom 5 sales

both(top and bottom 5) should show in a single object 

thanks in advance 

regards

siva

[dplr-rn · Accepted solution]

create a custom dimension like below

=If(Aggr(Rank(Sum(LineSalesAmount)) <= 5,SalesPerson) or Aggr(Rank(-Sum(LineSalesAmount)) <= 6,SalesPerson),SalesPerson)

[Brett_Bleess]

Siva, did Dilip's post help, or are you still trying to sort things out?  If the solution did work, please be sure to use the Accept as Solution button to mark it, so Dilip gets credit and others know it worked.  If you did something else, consider posting that and marking it, and if you are still working on things, leave an update, so we can try to come up with other ideas.

Regards,
Brett