topic Field Format issue in QlikView

Field Format issue

alec1982 — Tue, 27 Nov 2012 15:16:37 GMT

Hi Guys,

I am loading data from a SP List and one of the fields is Money formatted on the source.

when imported to QlikView I get the data to look like:

Revenue On the Source

float;#200.00000000 $200.00

float;#75.000000000 $75.00

float;#5000.0000000 $5000.00

not sure why I am getting the"float;#" before the nr

I tried to format the field in the in the script as Num() but didn't help.

Anybody has experienced any simillar issue.

Thxs for your help.

Alec

Anonymous — Tue, 27 Nov 2012 15:25:37 GMT

Hi Alec,

Not sure why you're getting the "float;#" part, but you can use:

Replace(Revenue, 'float;#','') as Revenue

MayilVahanan — Tue, 27 Nov 2012 17:21:49 GMT

Try like this

=Num(Replace('float;#200.00000000','float;#',''),'$#,##0.00') gives $200.00

so in load try like this

Load *,Num(Replace(Revenue,'float;#',''),'$#,##0.00') as Revenue from tablename;

Hope it helps