topic Re: Aggregated expression in QlikView

Aggregated expression

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

Hi,

Can some one help me here for below Aggregated Expression which i need to include some more values how can i do that.

Num(Avg(Aggr(Avg([PCINEW]), [PCINEWProjectID])),'#,##0')& '%',

i want to add below values as well.

[Project Status]<>'Completed','Merged','Cancelled'

[PSA Delivery Type]<>'Channel Partner'

[Project Creation Text]='Automatic by PG'

best Regards,

Re: Aggregated expression

raman_rastogi — Fri, 05 Oct 2018 11:24:10 GMT

Try this

Num(Avg(Aggr(Avg({<[Project Creation Text]={'Automatic by PG'},[PSA Delivery Type] -='{Channel Partner'} ,[Project Status]-={'Completed','Merged','Cancelled'}>}[PCINEW]), [PCINEWProjectID])),'#,##0')& '%'

Num(Avg(Aggr(Avg({<[Project Creation Text]={'Automatic by PG'},[PSA Delivery Type] ={'*'} - {'Channel Partner'} ,[Project Status]= {'*'} - {'Completed'}-{'Merged'}-{'Cancelled'}>}[PCINEW]), [PCINEWProjectID])),'#,##0')& '%',

Re: Aggregated expression

sunny_talwar — Fri, 05 Oct 2018 11:35:50 GMT

May be this

Num(Avg(Aggr(Avg({<[Project Status] -= {'Completed', 'Merged', 'Cancelled'}, [PSA Delivery Type] -= {'Channel Partner'}, [Project Creation Text] = {'Automatic by PG'}>} [PCINEW]), [PCINEWProjectID])),'#,##0') & '%',

Re: Aggregated expression

dunnalahk123 — Fri, 05 Oct 2018 12:25:23 GMT

Hi Sunny ,

Thank You so Much, it works.

Best Regards,

Re: Aggregated expression

dunnalahk123 — Fri, 05 Oct 2018 12:26:16 GMT

Hi Raman,

Thank You for your Reply. it also works fine.

Best Regards,