topic Problem number format in QlikView

Problem number format

carlos13 — Wed, 07 Mar 2012 21:14:21 GMT

Hello,

I have the following problem when I load a. Csv column I presented a balance '(' character which you remove with a Replace (@ 3, '(','') as balance, only now it takes me like a text and not a number and I can not use Sum (Balance) in the table simple

Problem number format

swuehl — Wed, 07 Mar 2012 21:55:48 GMT

I believe the balance numbers use a format with a decimal separator ',' which differs from your standard decimal separator and causes the problem.

If so, change the standard format to ',' or parse the balance numbers in using num#() function:

SET ThousandSep='.';

SET DecimalSep=',';

and/ or

Directory;

LOAD @1,

@2,

@3,

num#(Replace(@3,'(',''),'#',',','.') as Balance

FROM

test.csv

(txt, codepage is 1252, no labels, delimiter is ',', msq);

Problem number format

carlos13 — Wed, 07 Mar 2012 22:17:36 GMT

Thank you very much.