Top Performers with Exclusion

[Anonymous]

Hi everyone!

Situation:

I have a list of shops. A dashboard needs to be created with filter on product category and a bar chart of top 3 performers depending on the products selected. The trick is in the top 3 performers chart. It has to have one bar for shop A and the other two will be other 2 best performing shops (not bound to any particular shop).

Question:

Could anyone suggest me a way how i can get the described functionality running?

Thanks!

[laurentpaume · Accepted solution]

Hi,

There are many ways to achieve this.

You can either try a calculated dimension based on your performance indicators per shops.

Or you can use set Analysis :

https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/ChartFunctions/SetAnalysis/set-analysis...

You'll just have to find the best, optimized and easy way to use them depending on your datamodel.

Regards,

Laurent.