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]

Style tab select stacked option

[#3]

Hi,

I am not getting Top data. Please let me know  which expression I have to write.

[Gysbert_Wassenaar]

See attached example.

[sasiparupudi1]

Hi

I am able to see the top  data?

[#6]

Hi Gysbert,

I have used same expression in my qvw.

but is showing error in expression ( Red line)

[Gysbert_Wassenaar]

Make sure to use the exact case sensitive field names that exist in your document.

[#8]

Hi Frnz,

Please let me know any simple expression to get top account details.

I am using below expression.

=rangesum(max(AMID_VALUE,1),max(AMID_VALUE,2),max(AMID_VALUE,3),max(AMID_VALUE,4),max(AMID_VALUE,5),max(AMID_VALUE,6),max(AMID_VALUE,7),max(AMID_VALUE,8),max(AMID_VALUE,9),max(AMID_VALUE,10))

Instead of this, any alternative please.

[sasiparupudi1]

Hi

If you want the expressions to be simple, I suggest you go with Gysbert's solution

Sasi

[#10]

Hi,

Yes. I have tried this expression. But it is not working.

sum({<RANK={'<11'}>}AMID_VALUE)