Decile analysis with filter

eddy9657 — Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

I am using below logic from https://community.qlik.com/t5/QlikView-App-Dev/Decile-analysis/td-p/1223944.

=Aggr(

if(Sum(Profit) <= fractile(TOTAL Aggr(Sum(Profit), Customer), 0.1), 10,

if(Sum(Profit) <= fractile(TOTAL Aggr(Sum(Profit), Customer), 0.2), 9,

if(Sum(Profit) <= fractile(TOTAL Aggr(Sum(Profit), Customer), 0.3), 8,

if(Sum(Profit) <= fractile(TOTAL Aggr(Sum(Profit), Customer), 0.4), 7,

if(Sum(Profit) <= fractile(TOTAL Aggr(Sum(Profit), Customer), 0.5), 6,

if(Sum(Profit) <= fractile(TOTAL Aggr(Sum(Profit), Customer), 0.6), 5,

if(Sum(Profit) <= fractile(TOTAL Aggr(Sum(Profit), Customer), 0.7), 4,

if(Sum(Profit) <= fractile(TOTAL Aggr(Sum(Profit), Customer), 0.8), 3,

if(Sum(Profit) <= fractile(TOTAL Aggr(Sum(Profit), Customer), 0.9), 2, 1))))))))), Customer)

However , i want to create a filter to select the 10% or 20% customer then i can know about the max profit from second group 20% max profit. how can i create this

topic Decile analysis with filter in QlikView

Decile analysis with filter