Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
markgraham123
Specialist
Specialist

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
Master II
Master II

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
Specialist
Specialist
Author

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
Specialist III
Specialist III

757515.pngHey Mark can you provide some data ?

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

markgraham123
Specialist
Specialist
Author

Hi Ramon,

Rel% here is not the dimension and there is no "Dimension limits" in QV10 version11.png

ramoncova06
Specialist III
Specialist III

Let me think on something

ramoncova06
Specialist III
Specialist III

Hey Mark, how are you calculating your Rel%

markgraham123
Specialist
Specialist
Author

Its based on variables and aggregation.

Its a big calculation.

markgraham123
Specialist
Specialist
Author

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
Specialist III
Specialist III

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