CSV File changing fields (text to number, and decimal separators)
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.