Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
markp201
Creator III
Creator III

Load string as number

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

1 Solution

Accepted Solutions
markp201
Creator III
Creator III
Author

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.

View solution in original post

14 Replies
sunny_talwar

Try this may be

Num#(Amount, '#,##0.00')

markp201
Creator III
Creator III
Author

Same result.  Returns ?

Anonymous
Not applicable

are your system variables set like that?

SET ThousandSep=',';

SET DecimalSep='.';

sunny_talwar

Would you be able to share a sample?

markp201
Creator III
Creator III
Author

No change.

I've used num#(field) in a number of places and it works fine.  I don't why this is different.

Why the ?  I would expect null.

markp201
Creator III
Creator III
Author

This is a very simple script.  

LOAD num#(field) as field.

In other places it works fine

sunny_talwar

This is a document specific issue because when I try this.... it works for me

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET FirstWeekDay=6;

SET BrokenWeeks=1;

SET ReferenceDay=0;

SET FirstMonthOfYear=1;

SET CollationLocale='en-US';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

Table:

LOAD *,

  num#(Amount) as New_Amount;

LOAD * INLINE [

    Amount

    0.00

    800.00

    "1,203.12"

    901.00

    235.00

];

its_anandrjs

Did you read the data from any excel file. If possible share sample data.

Regards

Anand

settu_periasamy
Master III
Master III

not sure. May be check this..

Multiple Question mark in list box