How to get Min value through set analysis

[kunkumnaveen]

Hello All,

I have a data which has positives and Negative values  (Example  : 1000 -------->0--------->  -1000)

I am trying to get aggregated  8th Min  pact  value from 0 hence I tried with below expression which is not working 

Min(Aggr(sum(if(sum([pact])>0,[pact])),Buc,Exp),8)

Can any one suggest what is missing from the above expression

[chrismarlow]

Hi,

You seem to have 3 levels of aggregation in here and only 1 aggr, so think you may be missing a aggr? I am also not clear what the impact of aggregating over Buc/Exp fields is and if you want the single 8th smallest positive, or sum of 8 smallest?

Whichever I think you will need to sort your aggregation;

The sortable Aggr function is finally here! - Qlik Community - 1470262

Cheers,

Chris.