Discussion Board for collaboration related to QlikView App Development.
Hi All;I have a fied below that name is 'Value'I would like to show data such as 15,52 instead of 15.52So i would like to show comma(,) instead of point(.)
Thanks in advance...
Go to Solution.
To be correct
Change the number format for the field/listbox and give , as your decimal separator.
it does not work anyway.
Any idea ?
Use replace it will work. Search with replace in forum you will see number of examples
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
I use replace function and it works...Thanks.