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

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

Thu, 05 Aug 2010 16:22:23 GMT

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

Thu, 05 Aug 2010 16:50:04 GMT

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

Thu, 05 Aug 2010 16:54:37 GMT

just found this function in the moment....

Thanks very much

best regards

stefan