Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to convert values in textformat into value format?

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

1 Solution

Accepted Solutions
Or
MVP
MVP

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.

View solution in original post

2 Replies
Or
MVP
MVP

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.

Not applicable
Author

it works! thanks a lot.