Ranking bottom not working

[siri_v]

I need to do Top and Bottom Ranking of Rep based on metric (calculation sum(ABC)/sum(DEF)).I also have a variable dropdown to choose vRange.  Top Ranking works perfectly.

For the bottom ranking, I am unable to get it to work though I deselected to include Nulls. There are lot of Reps with 0 or very minimum value so I am getting blank.  To avoid this, I want to get only reps who have YTD sum(DEF) > 100

I tried to put this in calculation condition but I get error. Then I tried to create a measure
=aggr(if(rank(Sum({$<Year={"<2021"}>}DEF))>=0,rep),rep) .. even this does now work..

Can someone please advise how to do the bottom ranking.. I need to do ranking just for reps having sum(DEF) > 100 (or some threshold number)

[Ksrinivasan]

hi,

try this link

https://community.qlik.com/t5/QlikView-App-Dev/How-to-sort-the-Rank/td-p/922482#:~:text=How%20to%20s...

ksrini

[siri_v]

Thank you @Ksrinivasan  . This is definitely very useful.  In a straight table, I get the rank(sum(DEF)) correctly using this.. 

But my requirement is I am having a Bar chart for ranking.. The dimension is rep and measure is sum(ABC)/sum(DEF) 

how do I restrict the reps that have a very low sum(DEF) ? so that reps show in the bottom ranking Bar chart ? 

[Ksrinivasan]

hi,

you have to restrict or filter the low values in load script itself .

ksrinivasan