function to get the os language ( ie: French or English)

[#1]

Hi All,

What is th function to get the OS language or regional language of a computer?

Thanks

[swuehl · Accepted solution]

You can probably query the OS by using a VB macro (maybe using something like GetSystemDefaultUILanguage()) , or read from registry using QV function:

=GetRegistryString('HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Nls\Language\', 'InstallLanguage')

Then check the returned number:

http://msdn.microsoft.com/en-us/library/dd318693(v=vs.85).aspx

[#3]

Thanks Swuehl,

Now if we  want to change the language based on the regional setting language , how we can do it?

Thanks

[swuehl]

Maybe like described here:

http://community.qlik.com/message/194787#194787

Instead of field names and language field values German, English etc. use the language code you get returned from registry. Then use an OnOpen trigger with a select in field action to read the registry value and select in the language code field.

[#5]

Hi Swuehl,

We dicides to use this key:

=GetRegistryString('HKEY_CURRENT_USER\Control Panel\Desktop\','MultiUILanguageId')

But unfortunately it does not work  and it does not return any thing !

Do you have any idea?

Thanks