Why QlikView can not sum my field?

[brunolelli87]

Dears,

Why the system is returning 0 for my sum of column ValorAberturaAção? What's going on? 

Please, check the picture attached...

I have also tried to change it on LOAD, and now it's returning "dash" -, 
Check the attached picture

[javiersassen]

I think the issue is that you mix up the decimal separator and thousands separator. Have a closer look at that

[brunolelli87]

Hello, 

Thanks for your quick response.

The project I'm working with connects multiple web DataBase from different countries, (EUA and Brazil), and they have different definitions of thousand and decimal separators...

But, I've tried to invert it, and It's still not working, check the new attached picture I provided...

Thanks for your attention,

[Brett_Bleess]

If I am not mistaken the issue is the field values are coming in as Text, not Num, so in the load script, I would use the Num() on that field to ensure they come in as numbers, as you cannot sum text.  The left justification was the give away that told me it was coming in incorrectly as numbers right justify by default.  Best I can offer given information provided.  Apologies if I have misunderstood something.

Regards,
Brett