Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I have already checked on the "Finance Controlling" applications to see how to make my qvw document multi-lingual but I have still 2 situations where I can't find a way to traduce.
I explain:
1) Pivot Tables:
In my pivot tables, I can see the names of my fields but they are not multi-lingual. How can I get them translated dynamicaly?
2) In a Bar chart:
My legend is composed of the content of the field of one of my dimension. But how can I get them translated dynamicaly?
Thank you very much for your help 🙂
Hello, The way i do multilanguage is:
I have a table in the database with 3 columns: Language, TextToTranslate, Translation
I import this into the Qlikview file as a standalone table.
Then i have a listbox with the Language field. The listbox has the "Always one selected value" set under the listbox properties. (You need to select one value before u can set that property)
Then everywhere for labels, captions, dimensions et.c. i do this
=
MAXSTRING(IF(TextToTranslate = 'Customer', Translation, ''))
So for example if the table looks like this:
Language, TextToTranslate, Translation
English, Customer, Customer
Swedish, Customer, Kund
Norwegian, Customer, Kunde
And yuo have selected Swedish in the listbox then the result of
=MAXSTRING(IF(TextToTranslate = 'Customer', Translation, '')) will be Kund
Cheers
Martin
Hi Martin,
Thanks for the quick reply but What I really don't know is:
where can I put this code for the labels of the field (so, I mean each titles of each colums) in a pivot table. Like in the following image for the translation of Corporate_Id:
and where can I put this code for the legend of my bar chart (because if I put this on the label, then I get the only one label on top of all my possible values for the legend). Like in the following chart:
Thank you,
Caro.
Hi Martin,
I know about these places and I have tried and used these for expresions and some dimensions but in this case it is not what I am looking for.
You can look at the picture below. What you are suggesting is the "global" legend label. But I would like to traduce each field of the legend.
As you see here, when we use the label, we get a global title for the legend (here: Produit & Services). But I would like to translate the ones below that (Product & Services, Means of payment processing, local electronic banking...etc.)
Best Regards,
Caro.
Hello Caro,
Caro wrote:As you see here, when we use the label, we get a global title for the legend (here: Produit & Services). But I would like to translate the ones below that (Product & Services, Means of payment processing, local electronic banking...etc.)
The Label is Produit & Services. But the others below are values (member of your dim called Produit & Services) and come directly from the (database-)field belonging to the dimension. So if you want to translate them, you have to do it during the load. OK?
Regards, Roland
You use the same the approach as i mentioned before.
Instead of using a field you need to use calculated dimension
So if your field is Rev_rubric then it should be something like
=MAXSTRING(IF(TextToTranslate = Rev_rubric , Translation, ''))
All values for Rev_rubric need to be in the translation table.
Cheers
Oooops, didn't work as expected. Attached is a working solution. Cheers Martin
Hi Roland,
Yes, it is as you said the members of my dimension 😉
I have seen some other post about this solution but nothing quiety clear for me.. 😞 sorry I am relly just beginning with the QlikView coding.
Do you have any references to do it step by step?
One of the big doubt I still have with translation at load time is the following:
If in the qvw application I have buttons to change the language, would my label then be tranlated too? or is it just working for application when you chooses the language at start/load?
Thanks,
Caro.
Hi Martin,
Again thank you for taking the time to answer me.
I can't find you attachement 😉
Caro.