Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ranking

hi

i am trying to create a bar chart showing the top 5 countries with highest inflation rate.

i have three list boxes with details of country,capital and inflation rate.

what expression must be used??

explain the syntax in detail??

Labels (1)
1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     You can use this expression

=Sum({<Country={"=Rank(Sum(InflationRate))<6"}>} InflationRate)

Celambarasan

View solution in original post

5 Replies
Anonymous
Not applicable
Author

Hi

     the attached file will be use for your requirement

Regards

Ashok

Anonymous
Not applicable
Author

Hi

          Here i attached the same file with bar chart

Regards

Ashok

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     You can use this expression

=Sum({<Country={"=Rank(Sum(InflationRate))<6"}>} InflationRate)

Celambarasan

Not applicable
Author

is there any book or something like that from where i can learn the syntax of writing the expressions??

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     For set analysis you can use the attached material it will be usefull.

Celambarasan