Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
celambarasan
Not applicable

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
celambarasan
Not applicable

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
Not applicable

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