loading simple data

[#1]

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!!!

[maxgro · Accepted solution]

try with

SET ThousandSep=',';

SET DecimalSep='.';

or

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

[fred_s]

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

[#4]

Thanks a lot ... and it was so obvious