topic Re: Number format in QlikView

Number format

Tue, 03 Dec 2013 21:01:07 GMT

Hi All, I was trying to convert a value which is in text format to number.

I have field '0000000000000000158,15' in text format. I need this field en number format.

I try num ('0000000000000000158,15') but it isnt work.

Thanks and best regards

Ivan.

hic — Tue, 03 Dec 2013 21:26:54 GMT

There are too many digits. Try this instead:

Evaluate(Subfield(Number,',',1)) + Evaluate('0.' & Subfield(Number,',',2)) as Number

HIC

Wed, 04 Dec 2013 14:19:44 GMT

Try this instead but it isnt work.

This worked when divided into two instead.

I made.

One:

LOAD

num( replace(ltrim(replace(Evaluate(Subfield(@180:209,',',1)),'0',' ',)),' ',0)) as NumberI,

num(Evaluate('0.' & Subfield(@180:209,',',2))) as Number,

FROM

(fix, codepage is 1252);

Two:

LOAD

NumberI + Number as SDO_ACDO

Resident One