QlikSense mixed decimal sep in csv export

[chris3669]

Randomly QlikSense stores the CSV file with mixed decimal sep in the same file.

    SET DecimalSep=',';

    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?

[agigliotti]

what's DATA content ?

[chris3669]

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)

small snapshot

The fact that it ends with 2 decimal sep in the end feels buggy as it was stated that SET DecimalSep=',';

[chris3669 · Accepted solution]

So far, to solve the problem used replace(field, '.', ',') since num(field, '', ',') has no effect (just watch out if you have thousand separator)