Discussion board where members can get started with Qlik Sense.
Randomly QlikSense stores the CSV file with mixed decimal sep in the same file.
STORE DATA into [lib://data/file.csv] (txt, delimiter is \t);
Still get randomly column with the dot as decimal sep
Has anyone seen this kind of behavior before, and how to fix it?
Go to Solution.
So far, to solve the problem used replace(field, '.', ',') since num(field, '', ',') has no effect (just watch out if you have thousand separator)
what's DATA content ?
It is all numerical fields, can't provide more information as it has sensitive data.
All the math is done properly but the field (Previsto) remains with a distinct decimal sep even in the view
desvio_total = Ritmo - Previsto
desvio_absoluto = fabs(desvio_total)
The fact that it ends with 2 decimal sep in the end feels buggy as it was stated that SET DecimalSep=',';