bar chart

[#1]

hi

i am having three list boxes named country,capital,inflation rate. i want to create a bar chart showing the top 5 countries with highest inflation rates.

what expression must be used and explain the syntax in detail??

[v_iyyappan]

Hi,

     Use the Country as Dimension and Expression like = Sum(inflation rate) and and Sorting tab Y Value as ' Descending Order ',

Go to presentation tab and set the Dimension Limitations as Max visible no = 5,

Regards,

Iyyappan

[CELAMBARASAN · Accepted solution]

Hi,

     You can do it by the solution given by v.iyyappan if you want to restrict it by expression then you can go with this

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

Celambarasan

[#4]

its not working.it is arranging the inflation rate in descending order but not showing the top 5.

[v_iyyappan]

Hi

          I attach a sample file.Hopes its helpful for u.

Regards,

Iyyappan.

[#6]

thnx for the solution its working perfectly.

vitul

[CELAMBARASAN]

Hi,

     If it works for you then mark it as correct answer it will be helpful for others who searching the discussions with the same type of problem.

Celambarasan

[#8]

Hi

For showing top 5 value ,acorrding to that field keep its order descending then go presentation  check max visible number  and give value 5.

or you can do it more  interactinve by using variable eg (vtop ).

For it create a variable pass any value set its range for end user (he can choose how many values  want to see as highest record)

then use this variable '=$(vtop)' in max visible records in presentation.

I think it will help u.

[#9]

Hi Vitul,

I agree with Celambarasan statement. If you find the answer is right then mark it as correct answer, then only the people who ll face the same problem ll get benefit.