Top 10 from Dimension

[Pooja4]

I want to get Top 10 from dimension (Adj_Not_Null) on the basis of Measure which i have created from frontend (Sum({<Baseline = {"$(=Only([Var Analysis SC Value]))"}>} [Adj Value] * [Usd Conversion To Local Currency]) ), and this Top 10 i need to use in visualization with M_TO_K_CY_PY_Variance this measure. How to achieve it either from load editor or from UI level.

[MatheusC · Accepted solution]

Hi, @Pooja4,

We can't help you with this on the back end without knowing what your data model is like, but maybe you can analyze it to shorten your expression by sending this multiplication to the back end.

Table:
Load
*,
[Adj Value] * [Usd Conversion To Local Currency] as NewValue
from [....](qvd) ;

For classification, you can wrap your expression in the Rank formula inside the Rank()  set analysis.
https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Relationa....

sum({<Dimension = {"=Rank(Sum(YourExpression),4 )<=10"}>} NewValue) * change according to your data *

Since you said you need to use it in other views, you could leave this expression in a master item, this will save you time.

- Regards, Matheus

[vkramBI4Qlik · Accepted solution]

Hi ,

May be try like this..

Your Dimension :

=IF ( 
AGGR ( RANK ( Sum({<Baseline = {"$(=Only([Var Analysis SC Value]))"}>} [Adj Value] * [Usd Conversion To Local Currency]) ) , Adj_Not_Null ) <= 10  
, Adj_Not_Null )​

And Make sure to Uncheck the "Include Null Values" check box

Your Measure :

Sum({<Baseline = {"$(=Only([Var Analysis SC Value]))"}>} [Adj Value] * [Usd Conversion To Local Currency])

Thanks.

Vikram