topic Re: To convert comma to dot in decimal number in QlikView

To convert comma to dot in decimal number

Anonymous — Thu, 02 May 2013 06:49:05 GMT

Hi all,

Could any one give me the syntax to change a decimal number with "." (dot) instead of ","(comma).

From database I am fethcing a field value and storing its first value to a variable using peek function.

The values in that fields are decimal number like below.

var_Value = 0,7854

Now I want to chamge this value so instead of "," I want ".". (i.e., Instead of 0,7854 I want 0.7854)

Because I am using this value in calculation.

Can any one help me in this??

Thank you

Thu, 02 May 2013 06:53:41 GMT

use replace() function

=replace(var_Value,',','.')

Thu, 02 May 2013 06:55:28 GMT

replace('0,7854',',','.') returns 0.7854

er_mohit — Thu, 02 May 2013 07:04:39 GMT

try this

LOAD Replace(F1,',','.')as New, * INLINE [

"1,234"

"2,4567"

"4,678"

"12,4566"

"0,234"

"0,8449"

];

Thu, 02 May 2013 07:30:05 GMT

if your question is resolved then you have might to give either correct or helpful answer to closed this thread.

so that it might be helpful for other developers

Regards

vishwaranjan

Anonymous — Mon, 06 May 2013 11:59:04 GMT

Thanks for your solution. It worked. I didnt check your solution and that is the reason why I didnt mark my thread.

Sorry..

Thanks,

Leni Balakrishnan