Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
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
Master III
Master III

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
Master III
Master III

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.