11 Replies Latest reply: Oct 2, 2013 7:38 AM by Julio Lourenco RSS

    CSV File changing fields (text to number, and decimal separators)

      Hey guys,

       

      Nowadays I use excel files for a qlikview document, but it has taken quite long time to extract them from my program. We have as an alternative use .csv files, but when I load it, the fields comes as text, and the separator is "."... I want to change this separator to "," (comma as decimal separator), and them make qlikview read this text as numbers.

       

      I tryed to use num#() formula, but it's not working, i think it's due this separator.

       

      So, how do I change that?

       

      Thank you,