Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
dunnalahk123
Creator III
Creator III

Aggregated expression

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,

HK

1 Solution

Accepted Solutions
sunny_talwar

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') & '%',

View solution in original post

4 Replies
raman_rastogi
Partner
Partner

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')& '%',

sunny_talwar

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') & '%',

View solution in original post

dunnalahk123
Creator III
Creator III
Author

Hi Sunny ,

Thank You so Much, it works.

Best Regards,

HK

dunnalahk123
Creator III
Creator III
Author

Hi Raman,

Thank You for your Reply. it also works fine.

Best Regards,

HK