topic Re: String to number Num & NUm# not working in QlikView

String to number Num & NUm# not working

Fri, 05 Dec 2014 11:54:14 GMT

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.

Re: String to number Num & NUm# not working

PrashantSangle — Fri, 05 Dec 2014 11:56:35 GMT

Hi,

Can you elaborate with example

Regards

Re: String to number Num & NUm# not working

Gysbert_Wassenaar — Fri, 05 Dec 2014 11:56:39 GMT

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.

Re: String to number Num & NUm# not working

rajeshvaswani77 — Fri, 05 Dec 2014 11:58:51 GMT

Can you try this

Num(KeepChar(yourstring,'0123456789'))

thanks,

Rajesh Vaswani

Re: String to number Num & NUm# not working

MarcoWedel — Fri, 05 Dec 2014 12:00:48 GMT

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

Re: String to number Num & NUm# not working

rajeshvaswani77 — Fri, 05 Dec 2014 12:25:02 GMT

Can you try this

Num(KeepChar(yourstring,'0123456789'))

thanks,

Rajesh Vaswani

Re: String to number Num & NUm# not working

Mon, 08 Dec 2014 05:33:41 GMT

Thank you all for your quick responses.