Creating a Top 25(50, 100) sales button

[#1]

I'm trying to create a Top 25, 50, 100 sales button or slider that can easily show me the sales of inventory sold.

Any help would be appreciated!

[Michael_Tarallo]

Ah ok - you are using QlikView - that is great.

Stay connected to us and we will do the best we can to assist you.

Mike

Qlik

[rustyfishbones]

Hi Ashley,

The below should work, add a text object and add an action to Select in Field SalesPerson and add the following expression

='(' & CONCAT(IF(AGGR(RANK(Sum(Sales)),SalesPerson) <= 25,SalesPerson),'|') & ')'

In this case I am assuming your Metric is Sales and Dimension is SalesPerson

Hope it helps

Regards

Alan