Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

markgraham123
Contributor II

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.

11.png

9 Replies
buzzy996
Honored Contributor II

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.

markgraham123
Contributor II

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

ramoncova06
Valued Contributor III

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

757515.pngHey Mark can you provide some data ?

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

markgraham123
Contributor II

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 version11.png

ramoncova06
Valued Contributor III

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

Let me think on something

ramoncova06
Valued Contributor III

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

Hey Mark, how are you calculating your Rel%

markgraham123
Contributor II

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

Its based on variables and aggregation.

Its a big calculation.

markgraham123
Contributor II

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

Please let me know

ramoncova06
Valued Contributor III

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

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

Community Browser