Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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