Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Comma Instead of Point ?


Hi All;

I have a fied below that name is 'Value'

I would like to show data such as 15,52 instead of 15.52

So i would like to show comma(,) instead of point(.)

Value
15.52
15.53
15.55
15.62
15.64
15.66
15.74
15.82
15.85


Thanks in advance...

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Comma Instead of Point ?

To be correct


Replace(Value,'.',',');


6 Replies
Employee
Employee

Comma Instead of Point ?

Change the number format for the field/listbox and give , as your decimal separator.

Not applicable

Comma Instead of Point ?

it does not work anyway.

Any idea ?

Not applicable

Comma Instead of Point ?

Use replace it will work. Search with replace in forum you will see number of examples

Not applicable

Comma Instead of Point ?

To be correct


Replace(Value,'.',',');


Comma Instead of Point ?

Hi,

Depending on what you want to do in your document, you may need to change this variable in the main tab yof your script

SET DecimalSep='.'; // . instead of ,


You can use replace as well, but it may not work if you are going to say sum those values

LOAD Replace(value, ',', '.') as value FROM...


Hope that helps

Not applicable

Comma Instead of Point ?


I use replace function and it works...


Thanks.