topic pick function with aggr, possible? in QlikView

pick function with aggr, possible?

samuel_brierley — Fri, 07 Aug 2015 16:03:22 GMT

hi all,

the below equation is not working, not a clue why but can someone explain where im going wrong.

=pick(3,aggr(count({$<Fault_Classification = {'0','1','2','7'},
Fault_Code = {'-1','2','3','5','8','9','11','12','13','14','15','16','25','27'} >}Fault_Id),Equipment_Id))

ive replaced pick with max and min so im confident the aggr function is correct.

tahksn all.

Re: pick function with aggr, possible?

swuehl — Fri, 07 Aug 2015 16:13:56 GMT

What would be your expected result? I don't see a third argument in pick() function after your switch number.

pick( Number,

CaseNumberEquals1,

CaseNumberEquals2,

CaseNumberEquals3

)

Re: pick function with aggr, possible?

samuel_brierley — Fri, 07 Aug 2015 16:15:59 GMT

the intention was that the Aggr function would create the mini table and the pick function would pick the nth number in that table.

Re: pick function with aggr, possible?

swuehl — Fri, 07 Aug 2015 16:22:45 GMT

That's not like pick() works.

try maybe

=FirstSortedValue( {$<Fault_Classification = {'0','1','2','7'},
Fault_Code = {'-1','2','3','5','8','9','11','12','13','14','15','16','25','27'} >}

aggr(count({$<Fault_Classification = {'0','1','2','7'},
Fault_Code = {'-1','2','3','5','8','9','11','12','13','14','15','16','25','27'} >}Fault_Id),Equipment_Id)

, aggr(rowno() ,Equipment_Id), 3)