Moving aggregations to qlik scripting side

[deep2021]

Hi All,

Can you please suggest how to move below calculations in qlik scripting side?

sum(aggr(if(sum([AAgg.#_of_records])=0,1,0),E.entitlementGroup))
sum( aggr(if(only({<E.status={'ACTIVE'}>}E.accountType)='Service Account',1,0),E.entitlementGroup))

I have many expressions like this.

Need some advice.

Thanks

[Bill_Britt]

Hi, 

It would be somthing like this sum(aggr(if(sum([AAgg.#_of_records])=0,1,0),E.entitlementGroup)) as [Aggregated Value]

[deep2021]

Hi,

Thanks for the response,

Can you please suggest how the second expression can be written at the scripting side?

sum( aggr(if(only({<E.status={'ACTIVE'}>}E.accountType)='Service Account',1,0),E.entitlementGroup))

Thanks

[MayilVahanan]

Hi

Try like below

Load E.entitlementGroup, Sum(if(E.accountType='Service Account',1,0)) as ServiceAccountInfo resident yourtablename where E.status='ACTIVE' group by E.entitlementGroup;