Discussion Board for collaboration related to QlikView App Development.
I am trying to convert string to number.
Below values are coming in as string and I want to convert into number. When I use num() in backend it gives no values.
Can anyone help me?
if you want to keep your default separator settings though, you might as well load the Amount field like:
LOAD Num#(Amount,'#.##0,00',',','.') as Amount
hope this helps
Yes, that is correct. QV is usually excellent at (automatically) determining the correct format to use. In this case, using Num# will ensure that it's interpreted correctly (as a number) - just in case the decimal point and proceeding comma cause an issue. This should ensure that the field can be used in expressions.