Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Partner
Partner

Sum if Agg not working as expected

Hi to all im just wondering whats wrong with my set analysis ( see the attached pic)

Set analysis.PNG

my expected output in the top table should be 

MYR 4,427.78

SGD  8,330.63

IDR           0

THB         0 

PHP         0

 

thanks 

Labels (3)
3 Replies
MVP & Luminary
MVP & Luminary

Re: Sum if Agg not working as expected

No aggr needed. Try RangeMax(0, sum(Unreconciled))


talk is cheap, supply exceeds demand

Re: Sum if Agg not working as expected

I think @Gysbert_Wassenaar meant to use a comma

RangeMax(0, sum(Unreconciled))

Highlighted
MVP & Luminary
MVP & Luminary

Re: Sum if Agg not working as expected

Good point!

talk is cheap, supply exceeds demand