Ranking based on a conditional expression possible ?

[claudialet]

 I have a  pivot table with 2 dimensions.  Line1, Line2    

 Column is : Company 

 I have a variable slider :  vSlider       Values ranging from 0- 10 that controls the number of companies to display 

                                   Company A      Company B     Company C

Line1 >     

    Line2>            

Expression is : sum ( sales) 

 The ranking of the entire table needs to be based on this expression :  

 If  Line1 = 'abc' ,  rank(sales)

This expression is used in 'Sorting' for  'Company' dimension but it only ranks  when Line1 'abc' is selected. 

How can I get the entire pivot table to rank based on this expression ? 

Show top 'N' companies by sales based on Line1='abc' 

[jonathandienst]

The correct syntax for the expression would be

If(Line1 = 'abc', rank(sales))

but perhaps you need

Rank(If(Line1 = 'abc', sales))

[Sue_Macaluso]

Is this referring to QlikView or Qlik Sense? I would like to move it to the appropriate product forum as this is a general discussion forum and it will get more attention there.

[claudialet]

Qliksense