topic Re: Language Selector in QlikView

Language Selector

Anonymous — Sun, 30 Nov 2014 07:08:55 GMT

I have a specific requirement

I want to give the user the option to select language from available options that are applicable for a country.

The user should be able to select any available language and also be able to change the language if wanted.

E.g. Lang_Table:

Country Language

Russia English

Russia Russian

China Mandarin

China Wu

China Jin

India English

India Hindi

India Tamil

I don't want the user to even see the language of other country in the drop down.

Any ideas???

maxgro — Sun, 30 Nov 2014 09:10:08 GMT

see attachment for my idea

It uses OSUser and a trigger on the sheet.

Another option could be to use section access.

Anonymous — Sun, 30 Nov 2014 17:06:38 GMT

Yes this is right but not what I was looking for.

The users may have access to more than one country but when a country is selected only languages from that country should be visible.

Also 'hide excluded' does not serve the purpose as it hides the other languages for that country once a language is selected.

Any other solution!!!

prieper — Sun, 30 Nov 2014 17:47:22 GMT

You need to create a table, which has the language and the corresponding name for each item, which you would like to translate, like

Language, Title_Form1, Title_Form2, Name_Expression1, .....

Then also each object's descriptive elements need to refer to these Fields.

Selection of the language as proposed above (via Access), else it might be made by buttons within the application.

HTH Peter