topic How to convert values in textformat into value format? in QlikView https://community.qlik.com/t5/QlikView/How-to-convert-values-in-textformat-into-value-format/m-p/419686#M156147 <HTML><HEAD></HEAD><BODY><P>Hi all!</P><P></P><P>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.</P><P></P><P>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).</P><P></P><P>thanks!</P><P>David</P></BODY></HTML> Sun, 09 Dec 2012 15:25:15 GMT 2012-12-09T15:25:15Z How to convert values in textformat into value format? https://community.qlik.com/t5/QlikView/How-to-convert-values-in-textformat-into-value-format/m-p/419686#M156147 <HTML><HEAD></HEAD><BODY><P>Hi all!</P><P></P><P>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.</P><P></P><P>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).</P><P></P><P>thanks!</P><P>David</P></BODY></HTML> Sun, 09 Dec 2012 15:25:15 GMT https://community.qlik.com/t5/QlikView/How-to-convert-values-in-textformat-into-value-format/m-p/419686#M156147 2012-12-09T15:25:15Z Re: How to convert values in textformat into value format? https://community.qlik.com/t5/QlikView/How-to-convert-values-in-textformat-into-value-format/m-p/419687#M156148 <HTML><HEAD></HEAD><BODY><P>You seem to be using ',' as your decimal seperator:</P><P>SET DecimalSep=',';</P><P>Because your numbers have periods '.' as the decimal seperator, they're probably not getting read correctly. </P></BODY></HTML> Sun, 09 Dec 2012 15:35:58 GMT https://community.qlik.com/t5/QlikView/How-to-convert-values-in-textformat-into-value-format/m-p/419687#M156148 Or 2012-12-09T15:35:58Z Re: How to convert values in textformat into value format? https://community.qlik.com/t5/QlikView/How-to-convert-values-in-textformat-into-value-format/m-p/419688#M156149 <HTML><HEAD></HEAD><BODY><P>it works! thanks a lot.</P></BODY></HTML> Sun, 09 Dec 2012 21:09:19 GMT https://community.qlik.com/t5/QlikView/How-to-convert-values-in-textformat-into-value-format/m-p/419688#M156149 2012-12-09T21:09:19Z