Qlik Community

Qlik Sense App Development

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

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
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

Re: Rank() with greater than set analysis

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

Re: Rank() with greater than set analysis

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

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

View solution in original post

Highlighted
Partner
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

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
Partner

Re: Rank() with greater than set analysis

Ok thanks for your help!