Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
tm_burgers
Creator III
Creator III

Quartiles & AGGR

I have written the below measure - and it works correctly in a table with all the Names as the primary dimension - but when I select a specific Name dimension - the TOTAL part doesn't seem to work, and it only evaluates the formula based on the current selections - I would like it to always show the same Quartile results regardless of Dimension selections. 

 

if(aggr(All_Results,[Name]) <= fractile(TOTAL aggr( All_Results,[Name]), 0.25), '1Q - Bottom 25%',
if(aggr(All_Results,[Name]) <= fractile(TOTAL aggr( All_Results,[Name]), 0.5), '2Q - Top Half 50% ',
if(aggr(All_Results,[Name]) <= fractile(TOTAL aggr( All_Results,[Name]), 0.75), '3Q - Top 25%')))

 

Labels (2)
1 Reply
rbartley
Specialist II
Specialist II

HI @tm_burgers ,

 

I think it's because TOTAL only defines the scope of the aggregation, not the set of data over which the aggregation is performed.  If you're looking to ignore selections, you'll have to combine the scope with set analysis.  Take a look here:-

https://help.qlik.com/en-US/sense/May2023/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/define-agg...

If you post your app or an example here, it'll be easier to help.