How to get sum of top 5 values

[#1]

Hi Team ,

I have a requirement to get the sum of top 5 values .

The desired output is

Year  Desired o/p

2013   25

2014   25

For your reference I am attaching the sample qvw file.

[Clever_Anjos]

One possible solution

rangesum(

  max(Value,1),

  max(Value,2),

  max(Value,3),

  max(Value,4),

  max(Value,5)

)

[Colin-Albert]

The Dimension Limits tab on the chart properties allows you show Top N

[jonas_rezende]

Hi.

Please, attention to the items below.

1. *In which object you want to use this classification?

2. The classification requires another dimension. Ex.: Month, Customer, Region, etc.

3. *What is your version of Qlikview?

*Depend the object and version, would use aba Limit Dimension.

Anyway, a example follows link below.

https://community.qlik.com/thread/61030

[sasiparupudi1]

Please see the attachment

[sasiparupudi1]

Hi

Any update on this issue?

Sasi