Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Top Performers with Exclusion

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!

1 Solution

Accepted Solutions
laurentpaume
Partner - Contributor III
Partner - Contributor III

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.

View solution in original post

1 Reply
laurentpaume
Partner - Contributor III
Partner - Contributor III

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.