Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

zhaohaifeng
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)
1 Solution

Accepted Solutions

Re: Sum with duplicate data

You can try this as your expression

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

Re: Sum with duplicate data

maybe Sum({<A={CHC}>+<A={GEM}>} VALUE )
Highlighted
zhaohaifeng
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

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?

zhaohaifeng
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

Re: Sum with duplicate data

You can try this as your expression

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