topic Re: How to get Min value through set analysis in QlikView

How to get Min value through set analysis

kunkumnaveen — Tue, 01 Feb 2022 09:25:04 GMT

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

Re: How to get Min value through set analysis

chrismarlow — Tue, 01 Feb 2022 18:01:47 GMT

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.