Discussion Board for collaboration related to QlikView App Development.
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.
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.
View solution in original post
Can you elaborate with example
Can you try this
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
Thank you all for your quick responses.