Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

changing decimalpoint '.' to ',' while loading the data

Hi, it's me again....

normaly I'm using in my script Decimalpoint = ',' .

But now I have to load a field from an external datasource with a decimalpoint = '.'

further in my script I have to calculate this field with another field e.g. 27,45 * 0. 45

Is there a way to change the decimalpoint while reading or calculating this value?

Thanks & best regards

Stefan

1 Solution

Accepted Solutions
Not applicable
Author

Replace '.' to ',' or vice versa in a loading scrip and use the same decimal point in your application: 27,45 * 0,45 or 27. 45 * 0. 45

View solution in original post

2 Replies
Not applicable
Author

Replace '.' to ',' or vice versa in a loading scrip and use the same decimal point in your application: 27,45 * 0,45 or 27. 45 * 0. 45

Not applicable
Author

just found this function in the moment....

Thanks very much

best regards

stefan