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

[markgraham123]

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.

[buzzy996]

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.

[markgraham123]

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

[ramoncova06]

Hey Mark can you provide some data ?

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

[markgraham123]

Hi Ramon,

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

[ramoncova06]

Let me think on something

[ramoncova06]

Hey Mark, how are you calculating your Rel%

[markgraham123]

Its based on variables and aggregation.

Its a big calculation.

[markgraham123]

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????

Please let me know

[ramoncova06]

in theory yes, so you probably add could that in your expression