Solved: Re: String to number Num & NUm# not working - Qlik Community

Report Inappropriate Content · ‎2014-12-05

Hi All, how to convert a string to number? I have already tried Num and Num# functions. I am fetching data from SAP report. Please help. Thanks in advance.

Gysbert_Wassenaar · ‎2014-12-05

The num# function is used to create numbers from text values. num#(MyTextValue, '#,##0.00') as MyNumber

Note that num# is a qlikview function, so you cannot use it in sql statements which are executed by the database server and not by qlikview.

talk is cheap, supply exceeds demand

View solution in original post

PrashantSangle · ‎2014-12-05

Hi,

Can you elaborate with example

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Gysbert_Wassenaar · ‎2014-12-05

The num# function is used to create numbers from text values. num#(MyTextValue, '#,##0.00') as MyNumber

Note that num# is a qlikview function, so you cannot use it in sql statements which are executed by the database server and not by qlikview.

talk is cheap, supply exceeds demand

rajeshvaswani77 · ‎2014-12-05

Can you try this

Num(KeepChar(yourstring,'0123456789'))

thanks,

Rajesh Vaswani

MarcoWedel · ‎2014-12-05

A string should be implicitly converted to a number during load if it can be interpreted as numeric.

Without giving an example it's rather impossible to tell the cause of your issue.

hope this helps

regards

Marco

rajeshvaswani77 · ‎2014-12-05

Can you try this

Num(KeepChar(yourstring,'0123456789'))

thanks,

Rajesh Vaswani

Report Inappropriate Content · ‎2014-12-08

Thank you all for your quick responses.