Solved: Re: calculate function sum it doesn't work - Qlik Community

Report Inappropriate Content · ‎2012-12-12

hello

maby a stupid question

i am importing xml files in qlikview, then i will calculate the sum of all tickets.

but he don't do this

please help me

see attachment

Gysbert_Wassenaar · ‎2012-12-12

Your ThousandSep variable is set to a dot .

SET ThousandSep='.';

SET DecimalSep=',';

That causes your amounts to be treated as strings, since they're not valid numbers. If you change the dots and comma's it should work.

talk is cheap, supply exceeds demand

Gysbert_Wassenaar · ‎2012-12-12

Your ThousandSep variable is set to a dot .

SET ThousandSep='.';

SET DecimalSep=',';

That causes your amounts to be treated as strings, since they're not valid numbers. If you change the dots and comma's it should work.

talk is cheap, supply exceeds demand

Report Inappropriate Content · ‎2012-12-12

Gijsbert

weer bedankt!!!

mvg

anton