Discussion board where members can get started with QlikView.
I want to convert TEXT to NUMBER, but when i convert in the view table, do not say NUMBER FORMAT(not appear any format) and when I try to SUM() the convert field , the result is 0.
Please help, i attach the example .qvd
it have 2 object, one correct with the NUM# function(appears the value) and other with the sum() function that show 0(CERO)
if anybody can see, I apreciatte a lot !!!
Your num#() function doesn't work properly, but unfortunately num#() will return the original string, if the parsing failed.
(check by using num(num#(FIELD, FORMAT)) to see if the parsing worked out).
This should work, using a different format code and separator definitions:
View solution in original post
Thank you SWUEHL!!
thats work ok! another question pherhaps you know, I have another problem, do not recognize negatives value, it seems that they not numbers
if you select a negative value, its return -
thank you a lot!!
A negative value has a trailing minus sign in your case? Then you need to add the format for your negative values in the format code:
I want to Convert text to Number. My data is as follows:
I want to replace the ',' to a '.(Decimal)' and change the type from Text to Number.
Thanks this really solved my problem too.