Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
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
Valued Contributor II

Re: How to convert values in textformat into value format?

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
Valued Contributor II

Re: How to convert values in textformat into value format?

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

Not applicable

Re: How to convert values in textformat into value format?

it works! thanks a lot.