Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

sum Distinct

Hi everyone,

I want to sum duplicate values ​​but my formula doesn't work; sum = 2.278.314,5, but i want 1.139.157,3

Consider that I have other [Standard Family]

Aggr(DISTINCT sum({<Stream={'Idata'},Corporation={'San'},Periodo={'MTH10'}>} Tot),Stream)

tabla sum.png

Regards,

Labels (3)
2 Replies
Master II
Master II

Hi,

try to apply one more modifier filter as data classification split by Standard family TOU & LAN type. you have choose eigther then it will show expected results. 

Aggr(distinct sum({<Stream={'Idata'},Corporation={'San'},Periodo={'MTH10'},[Standard Family]={'TOU'}>} Tot),Stream)

Contributor II
Contributor II

Thanks, for Standard Family its Ok 1.139.157,27, but when I clean filters, Sum is incorrect, because I have another Standard Families