Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

danielco223
New Contributor III

Need Rank to always Rank on all Data regardless of selections

Hi, I have a Rank table that ranks sales territories based on sales. The below expression works great if no selections are made. 

Aggr(

Rank(

$(QTD_Sales),

),

[Territory Rep])


However, if a selection is made, say a specific rep is selected, their rank becomes 1. For example. TM Boston is 17 overall with no selections made.


2-8-2018 1-32-37 PM.jpg

but if I select TM Boston, then their rank changes to 1

2-8-2018 1-37-45 PM.jpg

I need it to stay 17.


I need the ranking to consider all of the reps regardless of which rep is selected so we can look at specific rep information and their overall rank.


Thanks!

1 Solution

Accepted Solutions

Re: Need Rank to always Rank on all Data regardless of selections

How is $(QTD_Sales) defined? You need to ignore selection in Territory field for the variable

2 Replies

Re: Need Rank to always Rank on all Data regardless of selections

How is $(QTD_Sales) defined? You need to ignore selection in Territory field for the variable

Digvijay_Singh
Honored Contributor III

Re: Need Rank to always Rank on all Data regardless of selections

May be in QTD_Sales variable inside Sum function you need to use set expression as {<Territory Rep=>} or any other field for which you want to disregard selections

Community Browser