Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

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


talk is cheap, supply exceeds demand
Highlighted

I think @Gysbert_Wassenaar meant to use a comma

RangeMax(0, sum(Unreconciled))

Highlighted
MVP & Luminary
MVP & Luminary

Good point!

talk is cheap, supply exceeds demand