Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

String to number Num & NUm# not working

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.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: String to number Num & NUm# not working

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

6 Replies

Re: String to number Num & NUm# not working

Hi,

Can you elaborate with example

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
MVP & Luminary
MVP & Luminary

Re: String to number Num & NUm# not working

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

rajeshvaswani77
Valued Contributor III

Re: String to number Num & NUm# not working

Can you try this

Num(KeepChar(yourstring,'0123456789'))

thanks,

Rajesh Vaswani

Re: String to number Num & NUm# not working

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
Valued Contributor III

Re: String to number Num & NUm# not working

Can you try this

Num(KeepChar(yourstring,'0123456789'))

thanks,

Rajesh Vaswani

Not applicable

Re: String to number Num & NUm# not working

Thank you all for your quick responses.