Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
leni_balakrishn
Creator III
Creator III

To convert comma to dot in decimal number

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

1 Solution

Accepted Solutions
Not applicable

use replace() function

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

View solution in original post

5 Replies
Not applicable

use replace() function

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

View solution in original post

Not applicable

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

er_mohit
Master II
Master II

try this

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

    F1

    "1,234"

    "2,4567"

    "4,678"

    "12,4566"

    "0,234"

    "0,8449"

];

Not applicable

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

leni_balakrishn
Creator III
Creator III
Author

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