topic Re: using aggr with set analysis in QlikView

using aggr with set analysis

Anonymous — Tue, 20 Dec 2016 13:00:45 GMT

I need to use aggr in the set analysis for sum.. existing is my syntax

sum({<[Referred to CPS] ={'Y'},Application={'HSBCNET'},[Service Lines]=,Month=,Weekstart=>}Aging_Sum)/count({<[Referred to CPS]={'Y'},Application={'HSBCNET'},[Service Lines]=,Month=,Weekstart=>}[Aging Buckets])

I need to put aggr as below but this is giving an incorrect syntax.. Need to group the sum by TR

sum(aggr({<[Referred to CPS] ={'Y'},Application={'HSBCNET'},[Service Lines]=,Month=,Weekstart=>}Aging_Sum), TR)/count({<[Referred to CPS]={'Y'},Application={'HSBCNET'},[Service Lines]=,Month=,Weekstart=>}[Aging Buckets])

Re: using aggr with set analysis

Anonymous — Tue, 20 Dec 2016 13:03:00 GMT

try (Change sum(aggr)

aggr(sum({<[Referred to CPS] ={'Y'},Application={'HSBCNET'},[Service Lines]=,Month=,Weekstart=>}Aging_Sum), TR)/count({<[Referred to CPS]={'Y'},Application={'HSBCNET'},[Service Lines]=,Month=,Weekstart=>}[Aging Buckets])

Re: using aggr with set analysis

sunny_talwar — Tue, 20 Dec 2016 13:09:31 GMT

May be this:

Sum({<[Referred to CPS] ={'Y'},Application={'HSBCNET'},[Service Lines]=,Month=,Weekstart=>} Aggr(Only({<[Referred to CPS] ={'Y'},Application={'HSBCNET'},[Service Lines]=,Month=,Weekstart=>}Aging_Sum), TR))/Count({<[Referred to CPS]={'Y'},Application={'HSBCNET'},[Service Lines]=,Month=,Weekstart=>}[Aging Buckets])

Re: using aggr with set analysis

Anonymous — Wed, 21 Dec 2016 05:25:32 GMT

Thanks Sunny.. Why has the Set analysis used twice i.e. before Aggr and again with Aggr ?