Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!
try with
SET ThousandSep=',';
SET DecimalSep='.';
or
Num#(Value, '#', '.', ',') as Value
try with
SET ThousandSep=',';
SET DecimalSep='.';
or
Num#(Value, '#', '.', ',') as Value
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
Thanks a lot ... and it was so obvious