topic Conditional set analysis with Aggr function in QlikView

Conditional set analysis with Aggr function

amber2000 — Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone,

I would like to rewrite this statement to add a condition (it works fine):

=sum({$<[PC_Wrapping_Errors] = {"1"}>}Aggr(max([PC_Colli_Checked]),[PC_Ass]))

It's only working for those records who have value 1 in PC_Wrapping_Errors.

I would like to add the following (this is my pseudocode:

Sum (if (PC_Wrapping_Errors] = {"1"}

then Aggr(max([PC_Colli_Checked]),[PC_Ass]))

Else Aggr(max([PC_Colli_Checked]),[PC_Pallet])))

Does anybody know how I can do this please?

I've tried this but it doesn't work:

//=if(PC_Wrapping_Errors > '1' ,Sum(Aggr(max([PC_Colli_Checked]),[PC_Ass])),

// if(PC_Wrapping_Errors < '0', Sum(Aggr(max([PC_Colli_Checked]),[PC_Pallet])))

kind regards,

Monique

Anonymous — Thu, 05 Jan 2017 13:33:22 GMT

may be this

//=if(PC_Wrapping_Errors = '1' ,Sum(Aggr(max([PC_Colli_Checked]),[PC_Ass])), Sum(Aggr(max([PC_Colli_Checked]),[PC_Pallet])))

amber2000 — Thu, 05 Jan 2017 13:41:40 GMT

Hi Allu,

It didn't work but after changing >1 into >= 1 it worked fine.

Than you so much.

Kind regards,

Monique