topic Re: Dealing with Multiple Languages in QlikView

Dealing with Multiple Languages

Wed, 11 Dec 2013 15:30:39 GMT

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

Re: Dealing with Multiple Languages

Anonymous — Thu, 12 Dec 2013 07:57:41 GMT

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

Re: Dealing with Multiple Languages

Thu, 12 Dec 2013 08:22:03 GMT

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.

Re: Dealing with Multiple Languages

qlikpahadi07 — Thu, 12 Dec 2013 10:07:35 GMT

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

Re: Dealing with Multiple Languages

Thu, 12 Dec 2013 10:37:21 GMT

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