topic qlik scenario in QlikView

qlik scenario

siva8 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: qlik scenario

dplr-rn — Wed, 11 Sep 2019 17:38:54 GMT

create a custom dimension like below

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

Re: qlik scenario

Brett_Bleess — Tue, 24 Sep 2019 15:10:21 GMT

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