Load string as number

[markp201]

Amount
0.00 800.00 1,203.12 901.00 235.00

I applied num#(Amount) as Amount and get

Amount
? ? ? ? ?

1. Why right-justified if its not a number?

2. Why the ? mark

[Anonymous]

did you try num(num#(FIELD)) ?

[markp201]

Same result.  Apparently Qlik can get confused about the formatting but this is straight-forward.  What's really weird is the ? appears for filters and dimensions but not for measures.  The measure looks fine but the user needs this in a table without aggregation.

[markp201]

Screen shot

[sunny_talwar]

How about if you just use Num(Amount) instead of Num#(Amount)?

[markp201 · Accepted solution]

Ok, this makes no sense but it works

Originally, pass 1

- load from a resident table

- one field uses applymap

- problem was on num#(field) as field.

On a guess, I resolved this with the following

Pass 1

- load from a resident table

- one field uses applymap

- problem solved by using a new field name - field as newfield.

Pass 2 restores the original field name

- loads from pass 1

- num#(newfield) as field

It's a small table - only mildly annoying.

Please just be happy it's solved - not looking for suggestions.  15 minutes till I can leave for the day.