Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
FranciscoQ
Partner
Partner

Replace dots with commas

Hi !

 

I am developing an App using the data load editor (script)

 

The thing is I connected The app with a website and I am downloading some currency exchange information.

 

The thing is that the numbers are with a dot, and i need them with a coma, ex:

 

DATE ; CE

10/10/03 ; 12.345

12/10/04 ; 13.567

 

etc, etc

And I need :

12,345 

13,567

etc etc

In the script I don't have the values, I have the fields:

Load

Date,

CE

FROM....

 

So I need to work with the fields, and the replace function doesn't work.

 

Maybe with Num or Num# but I don't know how to make them work,

 

I would appreciate some help,

 

Thanks !

2 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

You could try it with: num(num#(CE, '#.#', '.', ','))

- Marcus

Gui_Approbato
Creator III
Creator III

Adding to Marcus' answer, an alterantive would be using:

replace( CE, '.'  , ','  ) as CE