Converting string to numbers

[#1]

Hi:

I am trying to convert a field that can have a possible of 30 number with a max of 15 decimals in QlikView. I am doing,

Num(A_Value, '0.0')

Can someone let me know if this is correct

Thanks,

Tak

[#2]

Sry I didnot understand clearly....

If your A_Value is 1234.333444 then you should get 1234.3 not 4.3

check one more time and see my attachment....

[#3]

How do I get it to ensure that it is comparing what ever it is in the A_value and B_value. If A_value is 1234.333444, I need to ensure that it is comparing what ever maybe in that fields. If I were to use the code that I did, I will only get 4.3.

B_value may have 4.344 and the result would be 4.3 and will consider it to be a match when it should not be.

Num(A_Value, '0.0')

Thanks,

[MayilVahanan]

HI

Have doubt?

do u want like this?

1234.333444 -> 4.3

4.344 -> 4.3

are you want first decimal value. and ones in the number?

[CELAMBARASAN]

Hi,

You can try by using Num#(A_Value,'#')

[#6]

Hi:

I really need the value to be the same without any truncation or rounding.

if it have 20 digits and 10 decimal places, I need to keep it as is. Or if it has 15 digings and 5 decimal places, I need to also keep it as it.

Thanks,

[#7]

Hi:

I really need the value to be the same without any truncation or rounding.

if it have 20 digits and 10 decimal places, I need to keep it as is. Or if it has 15 digings and 5 decimal places, I need to also keep it as it.

Thanks,

[#8]

Will this keep the value the same regardless of how many digits or decimals?

Thanks,

[#9]

Will this keep the value the same regardless of how many digits or decimals?

Thanks,

[CELAMBARASAN]

Yes it will keep the whole thing. Didn't you checked it?

[#11]

It didn't seem to work. I was getting all the digits with 1 decimal place. I will check it again.

Thanks,