Converting text in numbers

[#1]

Hi guys!

I have a data with values like: 0,5, 0,69 and so on.

Qlikview doesnt recognize these values like numbers, so I need to convert them. I try like num#(Values,'#,##') and it convert values like 0,69  into numbers, however, leaving numbers like 0,5 as text.

And when i try num#(Values,'#,#') it convert 0,5in numbers and leaves 0,5 as text.

Any suggestions on how I can convert all the values into numbers?

[sagarkharpude]

You can use num(fieldname) ...

format numbers as follows num(fieldname,'00') on order to show all values like 01 or 04 and so on.

[#3]

Hi Diana,

num#(Values,'#,#', ',') should work for you, you'll need to set the decimal separator also

hope that helps

Joe

[#4]

Hi, Joe!

Unfortunately, it isn't working

[p_verkooijen · Accepted solution]

Try:

REPLACE(Value, ',', '.') AS Value

[PrashantSangle]

Hi,

use num#(Value,'#,00#')

Regards

[#7]

This worked perfectly great!

Thank YOU!!!

[#8]

Hi Diana,

Two ways you can try for this solution

1) Goto Number Tab in chart properties , from there u can change

2) num(num#()) you can use

[#9]

Hi..

Joe Simmons 

I want some real time scenario  and examples with expressions.

Please Help Me.

Thanks,

Srinu

[#10]

Hi

working good

Thanks