# Qlik Sense App Development

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for
Did you mean:
Highlighted Partner

## Rank() with greater than set analysis

Hi,

I have an expression than gives the sum of the top 10 sales

`Sum({\$<SalesPerson = {"=Rank(Sum(Sales))<=11"}>} Sales)`

I get that if I want the sum of the last 10 I would do

`Sum({\$<SalesPerson = {"=Rank(-Sum(Sales))<=11"}>} Sales)`

Unfortunately I have zero values that I would like to exclude from my calculation, I have

`Sum({\$<SalesPerson = {"=Rank( - Sum({\$<Sales={'>0'}>}Sales))<=11"}>} Sales)`

But it doesn't work.

Can anyone tell me what's wrong? Thanks!

1 Solution

Accepted Solutions
Highlighted MVP

## Re: Rank() with greater than set analysis

Looks okay, but try this (use [ ] instead of '  ')

`Sum({\$<SalesPerson = {"=Rank(-Sum({\$<Sales = {[>0]}>} Sales))<=11"}>} Sales)`
4 Replies
Highlighted MVP

## Re: Rank() with greater than set analysis

Looks okay, but try this (use [ ] instead of '  ')

`Sum({\$<SalesPerson = {"=Rank(-Sum({\$<Sales = {[>0]}>} Sales))<=11"}>} Sales)`
Highlighted Partner

## Re: Rank() with greater than set analysis

Great it works! Thanks a lot!
Does using square braquets mean you want to do a numerical comparison?

Highlighted MVP

## Re: Rank() with greater than set analysis

No, it just means that you cannot use another double quotes, because you have outer double quotes.

Highlighted Partner