9 Replies Latest reply: Jun 11, 2015 3:00 PM by Ramon Covarrubias

# Selecting top 25 % and top 50 % of percentages dynamically from a column

Hi Experts,

Can anyone tell me how can i dynamically fetch top 25 % and top 50 % of the "rel.%" without hardcoding the value.

Eager to learn.

• ###### Re: Selecting top 25 % and top 50 % of percentages dynamically from a column

u can do tis way,create variable and pass ur value either 25 or 50 one by one to input box of that variable.

and use that variable in ur expression by using aggr&rank function's for displaying <25 or 50% values.

• ###### Re: Selecting top 25 % and top 50 % of percentages dynamically from a column

Shiva,

Can you please elaborate on using the aggr&rank in expression to get top 25% of values.

Using rank and aggr i can get only top 25 or top 50 values.

But im looking fro top 25 % of values

• ###### Re: Selecting top 25 % and top 50 % of percentages dynamically from a column

Hey Mark can you provide some data ?

have you tried using the dimension limits in the straight table ?

• ###### Re: Selecting top 25 % and top 50 % of percentages dynamically from a column

Hi Ramon,

Rel% here is not the dimension and there is no "Dimension limits" in QV10 version

• ###### Re: Selecting top 25 % and top 50 % of percentages dynamically from a column

Let me think on something

• ###### Re: Selecting top 25 % and top 50 % of percentages dynamically from a column

Hey Mark, how are you calculating your Rel%

• ###### Re: Selecting top 25 % and top 50 % of percentages dynamically from a column

Its based on variables and aggregation.

Its a big calculation.

• ###### Re: Selecting top 25 % and top 50 % of percentages dynamically from a column

Caluclating Max(Rel.%) gives highest value which can be treated as 100th%

and Max(Rel.%)/2 as 50th %, Max(Rel.%)/4 as 25%....

Is this logic accurate????