Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

excluding the worst 10 - total sales

At least 10 sales except How do I calculate the total sales in text box.

1 Solution

Accepted Solutions
maxgro
MVP
MVP

if you rank sales by product maybe

SUM({<Product = {"=Rank(-SUM(Sales),4)>10"}>}Sales)

interesting docs about top performer

http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/08/displaying-the-top-salesperson-in-a-te...

Show Top Performers

View solution in original post

2 Replies
ashfaq_haseeb
Champion III
Champion III

Hi look at the attachment.

Regards

ASHFAQ

maxgro
MVP
MVP

if you rank sales by product maybe

SUM({<Product = {"=Rank(-SUM(Sales),4)>10"}>}Sales)

interesting docs about top performer

http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/08/displaying-the-top-salesperson-in-a-te...

Show Top Performers