Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
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

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

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

View solution in original post

4 Replies
Highlighted

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

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

View solution in original post

Partner
Partner

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

Highlighted

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

Highlighted
Partner
Partner

Ok thanks for your help!