Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

akuttler
Contributor

Sum Total with Set modifier Distinct Field

Hello I am trying to sum total encounter charges for distinct ENCID's.

I tired the expression below but it gives me 0.00

Sum({<ENCID={'Distinct ENCID'}>}[ENCID Total Charges])

Thanks in advance.

Tags (2)
1 Solution

Accepted Solutions

Re: Sum Total with Set modifier Distinct Field

Did you forget to add DISTINCT?

Sum (Aggr (Sum(DISTINCT [ENCID Total Charges]), ENCID))

4 Replies
thiago_justen
Valued Contributor III

Re: Sum Total with Set modifier Distinct Field

Try this:

Sum (Aggr (Sum([ENCID Total Charges]), ENCID))

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago

Re: Sum Total with Set modifier Distinct Field

Did you forget to add DISTINCT?

Sum (Aggr (Sum(DISTINCT [ENCID Total Charges]), ENCID))

thiago_justen
Valued Contributor III

Re: Sum Total with Set modifier Distinct Field

My fault stalwar1‌. You're right!

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
akuttler
Contributor

Re: Sum Total with Set modifier Distinct Field

Thank you! It works.

Community Browser