Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
kamal_sanguri
Valued Contributor

Re: SUM AGGR

Try this..

Aggr(Sum(DISTINCT [Vacancy FTE]), [Job Ref], [Vacancy FTE],[Vacancy State],[Vacancy Stage]).

Also add Job Ref as dimension. See, if that works for you

Capture.PNG

philmywallet
Contributor

Re: SUM AGGR

This works.

Thanks

Phil