Dealing with Multiple Languages

[#1]

Hello community,

I have a question regarding multiple languages in a qvw:

I have two sources of translated text. One is a Excel sheet and the other one comes from two db columns ("categories", "types") where "categories" looks like this:

"03 Deutscher Text 1 / English Text 1"

With support in this thread

I manged to split the strings to German and English text.

I want to us both of the above mentioned db columns as one listbox each (depending on the language selection).

At the moment I've created two columns for each db column and do a conditional show/hide.

For example: =if(GetFieldSelections(_LANGUAGE) = 'English', 1, 0)

I added my qvw example.

Hope you can help me out here.

Thank you,

Thorsten

UPDATE: NEW QVW

[Anonymous]

Pardon me if i am not understanding your issue here.

But according to your description, what you want, looks like you have already achieved. One list box showing the values based on the language selection. Is this not what you want.

What exactly are you trying to achieve here.

Regards,
Aadil

[#3]

The listbox in my example contains all values.

But I want one listbox for categories and one for types - those come from the db. All other translations are stored in Excel and are used only for headings and descriptive text.

So if column categories contains these two records:

  03 Deutscher Text 1 / English Text 1

  04 Deutscher Text 2 / English Text 2

My listbox for categories should only show either the German or English Text of those two records when the according language is selected.

Hope that made it a bit clearer now.

[qlikpahadi07]

Hi Thorsten,

Suggestion as you have already done for one List box in upper case you can split your "String" field  from back-end something like :

SubField(String,'/',2) as Engilsh,

SubField(String,'/',1) as German

and then you can work with same

[#5]

see my updated QVW to understand what I like to achieve.