Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
chris3669
Contributor III
Contributor III

QlikSense mixed decimal sep in csv export

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

2018-10-08 11_35_00-robot_py [C__Users_christian_Documents_robot_py] - ..._s3_avaliacao_entregas_coo.png

Has anyone seen this kind of behavior before, and how to fix it?

1 Solution

Accepted Solutions
chris3669
Contributor III
Contributor III
Author

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

View solution in original post

3 Replies
agigliotti
Partner - Champion
Partner - Champion

what's DATA content ?

chris3669
Contributor III
Contributor III
Author

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

2018-10-08 12_25_59-VIEW_PLAN_Follow_Up_Entregas - My new sheet (4) _ Sheets - Qlik Sense.png

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

chris3669
Contributor III
Contributor III
Author

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