Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
One possible solution
rangesum(
max(Value,1),
max(Value,2),
max(Value,3),
max(Value,4),
max(Value,5)
)
The Dimension Limits tab on the chart properties allows you show Top N
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.
Please see the attachment
Hi
Any update on this issue?
Sasi