How to write expr to show Top 5,10,15 sum in Bar chart?

[#1]

Hi Frnz,

I need to show Top 5 ,Top 10, Top 15 Accounts Sum in One Bar chart. Please help me to find this.

Please find the attached QVW. You will get clear idea.

[sasiparupudi1]

I do not see AMID_VALUE filed in your script in the qvw?

[#3]

hi,

actually for example i have mentioned AMID_VALUE..I tried same expression in my scenario. And there is no mistake in field also. May be data problem. I am not getting..

Thanks,

Tulasiram

[sasiparupudi1]

so are you saying that the

sum({<RANK={'<6'}>}L4AMID_VALUE_USD) is not returning the same values as

rangesum(max(L4AMID_VALUE_USD,1),max(L4AMID_VALUE_USD,2),max(L4AMID_VALUE_USD,3),max(L4AMID_VALUE_USD,4),max(L4AMID_VALUE_USD,5))

?

There must be something wrong in your data then ..both solutions work well with your original QVW file

[#5]

Hi,

Yes. Thanks for your help Sasidhar.