Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

ranking

how to use ranking in the qlik view???

i have a column named country and other as population. i want to  show the top 5 countries on the basis of population through a bar chart. how to use the ranking expression in it??

1 Solution

Accepted Solutions

ranking

Hi,

     Try with this expression

=Only({<Country={"=Rank(Population)<6"}>} Population)

     Or

     If your using QV 9

       use expression as Only(Population)

      Then go to the properties-->Presentation-->under dimension limitations check the option max visible number and set as 5.This requires to be sort by y value descending.

     Or

     for 10 and 11

     use dimension limits

Celambarasan

2 Replies

ranking

Hi,

     Try with this expression

=Only({<Country={"=Rank(Population)<6"}>} Population)

     Or

     If your using QV 9

       use expression as Only(Population)

      Then go to the properties-->Presentation-->under dimension limitations check the option max visible number and set as 5.This requires to be sort by y value descending.

     Or

     for 10 and 11

     use dimension limits

Celambarasan

jason_michaelid
Honored Contributor II

ranking

I don't think you need to use ranking for this.  Just sort your bar chart by population descending and limit the displayed values to 5.

Hope this helps,

Jason