Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

calculate function sum it doesn't work

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

1 Solution

Accepted Solutions

Re: calculate function sum it doesn't work

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
2 Replies

Re: calculate function sum it doesn't work

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
Not applicable

Re: calculate function sum it doesn't work

Gijsbert

weer bedankt!!!

mvg

anton

Community Browser