Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
did you try num(num#(FIELD)) ?
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.
Screen shot
How about if you just use Num(Amount) instead of Num#(Amount)?
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.