Sum all values - including duplicates

[sgqliker]

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

[MarioCenteno]

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]

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]

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!