topic Top 10 from Dimension in Talend Studio

Top 10 from Dimension

Pooja4 — Fri, 02 Jan 2026 14:45:42 GMT

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.

Re: Top 10 from Dimension

MatheusC — Thu, 26 Jun 2025 19:42:18 GMT

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/RelationalFunctions/rank.htm#:~:text=Rank()%20evaluates%20the%20rows,dimension%20evaluated%20in%20the%20expression.

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

Re: Top 10 from Dimension

vkramBI4Qlik — Fri, 27 Jun 2025 06:45:58 GMT

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