Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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