topic Multilanguage for Column Name in App Development

Multilanguage for Column Name

w0jt4z — Wed, 13 May 2020 09:11:42 GMT

Hi Everyone,
I try find a solution for my little problem. I want to translate Column name. All of problem concerns translation for Values. I want to translate Column, for example I Have Columns: Sales, Quantity. On the app I want to translate it, For example English Country, City , in Polish it is Kraj, Miasto. I have separeted table for this names, but I can't to relate it with column name, only with a Values. I have table with geo data, for example, Country, City, etc. The value is for example USA, England and for the City NYC, London. I don't want translate this Values, just Column Names. How can I do that? I know I can write the condition with just string, if 'English then Country, If Polish then Kraj', but I have many, many columns to translate and I don't want to do it this way.
Anyone can help me?

Re: Multilanguage for Column Name

fosuzuki — Wed, 13 May 2020 09:17:31 GMT

Hello,

have you seen this: https://community.qlik.com/t5/Qlik-Design-Blog/Making-a-Multilingual-Qlik-Sense-App/ba-p/1678131?

Re: Multilanguage for Column Name

w0jt4z — Mon, 18 May 2020 10:40:26 GMT

Doesn't work 😞 Maybe I did something wrong. But I tried to do it in another way.
I did something like that:

AttributesTranslation:
LOAD
AttributeId as Index,
"1" AS Polish,
"2" AS English
FROM [lib://QVD_Generator (win-f2om7p4maoo_followup)/Transformed/AttributeTranslations.qvd]
(qvd);

On the app I added variable input with variable vLanguage and values English and Polish. On my dimension Label I wrote:
=Only({<Index = 1>} $(vLanguage))

It doens't work too, i had "-" in header, but I thing it may be good way, because the variable is changin'. (On the screenshot).

Maybe it is because of changin' names AttributeId as Index, 1 as Polish, 2 as English?

Re: Multilanguage for Column Name

w0jt4z — Mon, 18 May 2020 18:37:07 GMT

Ok, I got it. I didn't have the table with languages. So that solution is correct, thank You! 🙂