Re: Sum field B if field A is distinct - Qlik Community

Report Inappropriate Content · ‎2013-04-01

Dears,

How can I sum all the values of field B, only if field A is distinct.

In other words.

Collect all distinct values of field B, and sum its column A value.

Thanks per your attention,

Best regards,

kaushiknsolanki · ‎2013-04-01

Hi,

Would you please give an example for more clarification.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2013-04-01

Sum({<Distinct SN>} TotalLabor)

SN the number to be distinct

TotalLabor the number to be summed!

Thanks

Report Inappropriate Content · ‎2013-04-01

Sum({<Distinct SN>} TotalLabor)

SN the number to be distinct

TotalLabor the number to be summed!

Thanks

kaushiknsolanki · ‎2013-04-01

Hi,

Could you please explain with example.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

jagan · ‎2013-04-01

Hi,

It is not possible, you need to arrive a flag for the first value in the script , so that you can directly sum up the values.

Can you please come up with sample data and example.

Hope this helps you.

Regards,

Jagan.

Report Inappropriate Content · ‎2015-09-16

You probably already had solved this problem,however, recently I've tryied to solve that question and it was not too easy to be solved.

It could be solved with it:

sum(aggr(sum(DISTINCT B), A))

deshikas · ‎2016-05-23

Had the same issue your solution fixed for me. Thanks Luiz