Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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

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

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

2 Replies
Not applicable

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

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

AW:Re: changing decimalpoint '.' to ',' while loading the data

just found this function in the moment....

Thanks very much

best regards

stefan