Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Gijsbert
weer bedankt!!!
mvg
anton