How to convert values in textformat into value format?

[#1]

Hi all!

I´ve got troubles importing the file attached "input.txt". Once imported all amount values are recognized in Qlickview as text format and I can´t sum up. The expected result for amount in july should be 76,49 eur.

How can I convert the textformat into value format in order to allow additions? I am attaching both files input.txt (original) and input.qvw (import result).

thanks!

David

[Or · Accepted solution]

You seem to be using ',' as your decimal seperator:

SET DecimalSep=',';

Because your numbers have periods '.' as the decimal seperator, they're probably not getting read correctly.

[#3]

it works! thanks a lot.