# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor III

## Sum with duplicate data

Hi All,

For some case :

Sum({<A={CHC}>} VALUE ) + Sum({<A={GEM}>} VALUE )  are not matched with Sum({<A={CHC,GEM}>} VALUE )  as the duplicate data, my question was that if we want to calculate all the value not carethe duplicate like Sum({<A={CHC}>} VALUE ) + Sum({<A={GEM}>} VALUE ) , how can we edit the expression dont used this way one + one. Thanks for your time!

Best Regards,

Haifeng

Labels (1)
• ### Duplicate data

1 Solution

Accepted Solutions
MVP

## Re: Sum with duplicate data

You can try this as your expression

`Sum(Aggr(Sum(value), AA, org))`
5 Replies
Partner

## Re: Sum with duplicate data

maybe Sum({<A={CHC}>+<A={GEM}>} VALUE )
New Contributor III

## Re: Sum with duplicate data

Hi,

If we need to calculate all the items, in this way we need to write many set analysis, A=CHC + A=GEM+A=AAA+ and so on, so do you know any other ways ? Thanks.

Best Regards,

Haifeng

MVP

## Re: Sum with duplicate data

AFAIK Sum({<A={CHC}>} VALUE ) + Sum({<A={GEM}>} VALUE) will always equal Sum({<A={CHC,GEM}>} VALUE)... can you share a scenario where they are not?

Highlighted
New Contributor III

## Re: Sum with duplicate data

Thanks .

See attached file, the sum value we want to show 700, not 600. Can you share some ideas? Thanks.

Best Regards,

Haifeng

MVP

## Re: Sum with duplicate data

You can try this as your expression

`Sum(Aggr(Sum(value), AA, org))`