topic bar chart in QlikView

bar chart

Wed, 15 Feb 2012 12:08:44 GMT

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??

Re: bar chart

v_iyyappan — Wed, 15 Feb 2012 12:16:37 GMT

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

bar chart

CELAMBARASAN — Wed, 15 Feb 2012 12:21:42 GMT

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

bar chart

Thu, 16 Feb 2012 05:11:48 GMT

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

Re: bar chart

v_iyyappan — Thu, 16 Feb 2012 05:22:08 GMT

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

Regards,

Iyyappan.

bar chart

Thu, 16 Feb 2012 05:35:33 GMT

thnx for the solution its working perfectly.

vitul

bar chart

CELAMBARASAN — Thu, 16 Feb 2012 05:59:35 GMT

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

Re: bar chart

Thu, 16 Feb 2012 06:15:59 GMT

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.

Re: bar chart

Thu, 16 Feb 2012 06:33:10 GMT

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.