topic Re: loading simple data in QlikView

loading simple data

Sat, 21 Mar 2015 19:04:27 GMT

Hey all,

I experience an issue loading some data. I try to load a .dat file containing simple data. But I can't calculate anything with the numbers which have this format "100.0". Why QlikView doesn't interpret those figures as integers with decimale "."? Even with things like Num#(Value, '.') nothing works. Simple example:

LOAD * INLINE [

Product, Country, Value

A, USA, 100.0

B, UK, 200.0

C, FR, 300.0

];

While loading this inline I can't calculate Sums with the column "Value" .... why?

Thanks for reply!!!

Re: loading simple data

maxgro — Sat, 21 Mar 2015 19:42:55 GMT

try with

SET ThousandSep=',';

SET DecimalSep='.';

or

Num#(Value, '#', '.', ',') as Value

Re: loading simple data

fred_s — Sat, 21 Mar 2015 21:31:49 GMT

Or in addition to Massimo, use this:

Load

Product,

Country,

replace(Value, '.', ',') as Valuenew

;

LOAD * INLINE [

Product, Country, Value

A, USA, 100.0

B, UK, 200.0

C, FR, 300.0

];

Grtz Fred

Re: loading simple data

Sat, 21 Mar 2015 22:19:50 GMT

Thanks a lot ... and it was so obvious