Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

chris3669
New 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
New Contributor III

Re: QlikSense mixed decimal sep in csv export

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

3 Replies
Partner
Partner

Re: QlikSense mixed decimal sep in csv export

what's DATA content ?

chris3669
New Contributor III

Re: QlikSense mixed decimal sep in csv export

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
New Contributor III

Re: QlikSense mixed decimal sep in csv export

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