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
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sgqliker
Contributor II
Contributor II

Sum all values - including duplicates

Hi all,

I want to sum all of my values in the variable 'Weighting Factor',

Qlik is removing duplicate values as default, even though I want to sum everything.

I end up with a sum of all of the unique weighting factors by default.

Is there a way to do "sum ([Weighting Factor])" but add something that would force Qlik to include everything?

Thanks

3 Replies
MarioCenteno
Creator III
Creator III

May be try this

Example

Sum(Aggr(sum(Distinct sales),[Weighting Factor]))



You could expand more your information to be able to help you better.

swuehl
MVP
MVP

Sophie,

summing up all record values, including duplicates - this should be the default for Sum(FIELD).

What makes you think that it is the other way around?

Can you post a scenario where Sum(FIELD) does only sum the distinct values, e.g. using a sample QVF or some screenshots (that need to show the records and the output of the expression)?

sgqliker
Contributor II
Contributor II
Author

Thanks for your reply, the newest data load had been changed to remove duplicates by another user, but this has been changed back and working correctly now.
Thanks!