topic Re: Converting text in numbers in QlikView

Converting text in numbers

Tue, 24 Mar 2015 10:28:16 GMT

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?

Re: Converting text in numbers

sagarkharpude — Tue, 24 Mar 2015 10:31:34 GMT

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.

Re: Converting text in numbers

Tue, 24 Mar 2015 10:41:25 GMT

Hi Diana,

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

hope that helps

Joe

Re: Converting text in numbers

Tue, 24 Mar 2015 10:48:43 GMT

Hi, Joe!

Unfortunately, it isn't working

Re: Converting text in numbers

p_verkooijen — Tue, 24 Mar 2015 10:51:51 GMT

Try:

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

Re: Converting text in numbers

PrashantSangle — Tue, 24 Mar 2015 10:56:34 GMT

Hi,

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

Regards

Re: Converting text in numbers

Tue, 24 Mar 2015 10:59:55 GMT

This worked perfectly great!

Thank YOU!!!

Re: Converting text in numbers

Tue, 24 Mar 2015 11:00:39 GMT

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

Re: Converting text in numbers

Tue, 24 Mar 2015 17:58:17 GMT

Hi..

Joe Simmons

I want some real time scenario and examples with expressions.

Please Help Me.

Thanks,

Srinu

Re: Converting text in numbers

Thu, 26 Mar 2015 13:55:07 GMT

working good

Thanks