topic Comma Instead of Point ? in QlikView

Comma Instead of Point ?

Thu, 07 Oct 2010 12:24:22 GMT

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...

Comma Instead of Point ?

kji — Thu, 07 Oct 2010 12:25:19 GMT

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

Comma Instead of Point ?

Thu, 07 Oct 2010 12:32:12 GMT

it does not work anyway.

Any idea ?

Comma Instead of Point ?

Thu, 07 Oct 2010 12:49:21 GMT

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

Comma Instead of Point ?

Thu, 07 Oct 2010 12:52:13 GMT

To be correct


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

Comma Instead of Point ?

Miguel_Angel_Baeyens — Thu, 07 Oct 2010 12:54:37 GMT

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

Comma Instead of Point ?

Thu, 07 Oct 2010 13:13:21 GMT

I use replace function and it works...

Thanks.