topic Re: System variable settings overridden by local Region and Language settings in QlikView

System variable settings overridden by local Region and Language settings

Tue, 07 Jan 2014 06:00:46 GMT

Hi Friends,

I see the System Variable settings applied in the document are being overridden by the local Region and Language settings of the OS, to be specific my data uses '.' as decimal separator where as it is being interpreted as a thousands separator according to OS settings.

Is there any known work around to prevent this misinterpretation friends? I have given a try with Num function but didnt help eigther

Thank you,
Raj

Re: System variable settings overridden by local Region and Language settings

Tue, 07 Jan 2014 07:43:42 GMT

Hi Raj,

Have you tried setting the separators symbols in Separator section of Number tab?

Might be of help.

Re: System variable settings overridden by local Region and Language settings

Tue, 04 Feb 2014 04:04:21 GMT

Thanks Shyamal for reply,

I found the problem is at Ms Access selection query level itself, from the Access SQL the data returned is already formatted before it reaches the QV Load statement, resolved this by resetting the Region & Language settings.

Best Regards,

Rajesh