Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
shekharnil
Contributor III
Contributor III

Language Selector

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???

3 Replies
maxgro
MVP
MVP

see attachment for my idea

It uses OSUser and a trigger on the sheet.

Another option could be to use section access.

shekharnil
Contributor III
Contributor III
Author

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
Master II
Master II

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