How to do ALLEXCEPT function in qlik sense

[Rajitha1]

I need to replicate below dax query in qlik sense

AGC per Mt = sum('PROFIT_AND_LOSS_TGT (IFFCO)_Mig'[Gross Contribution Per Mt])/calculate(sum('PROFIT_AND_LOSS_TGT (IFFCO)_Mig'[Gross Contribution Per Mt]),ALLEXCEPT('PROFIT_AND_LOSS_TGT (IFFCO)_Mig','PROFIT_AND_LOSS_TGT (IFFCO)_Mig'[Gross Contribution Per Mt]))

[Rajitha1]

Can anyone help me regarding this.

[MayilVahanan]

Hi

Try like below

sum([Gross Contribution Per Mt])/sum({1<[Gross Contribution Per Mt] =p ([Gross Contribution Per Mt])>}[Gross Contribution Per Mt])

Above exp, ignores all the selections and include only the possible values for the selections. Hope it helps.

In order to ignore all the fields, we are using {1}, however if want to ignore only certain fields, we can use

City=, Country=
Ex:
sum({1<[Gross Contribution Per Mt] =p ([Gross Contribution Per Mt]), City=, Country=>}[Gross Contribution Per Mt])

If you want to ignore by table wise, I hope, you need to mention all the fields like above.