New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save \$400. Learn More
Highlighted
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?

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))