topic Re: Multi-language months label in QlikView

Multi-language months label

marco_lapolla — Wed, 01 Dec 2021 13:50:28 GMT

I'm developing a dashboard in two different languages: English and Spanish.
I've created two different set in a data load editor:

Set MonthNames_ENG='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
Set MonthNames_ESP='Enero;Feb;Mayo;Jun;Agosto;Sept;Oct;Nov;Dic.';

I want to show the month list in a filter box and switch the language of those months to another filter box

How can i do?

Re: Multi-language months label

Or — Wed, 01 Dec 2021 13:55:00 GMT

Unfortunately, you can't do that script-side using the variables. You'll need to set up separate fields and use front-end formulas to pick which field to display based on the language selection.

Have a look at the solution proposed here - you probably want something similar.

https://community.qlik.com/t5/QlikView-App-Dev/set-monthname-multi-langauge/td-p/222059

Re: Multi-language months label

marco_lapolla — Wed, 01 Dec 2021 15:00:03 GMT

It doesn't work.

I try to explain my scenario.
I have a main table with 3 columns

closing_date	code	capital
12/1/2018 12:00.00 AM	ABC	15000
11/2/2018 12:00.00 AM	CDA	25000
11/4/2018 12:00.00 AM	CAA	20000

My target is to filter the records by the closing_date
To do it I created a filter box using the fx [closing_date.autoCalendar.Month]
In this way the filter box is populated with the months of closing_date.

For example:

January

February

April

My dashboard is multi-language.
I use a Filter Box populated by field #LANGUAGE created using this code.

Language: CROSSTABLE (Language, Translations) LOAD INDEX, ENG, SPA RESIDENT Translations; LanguageList: LOAD Distinct Language as #LANGUAGE RESIDENT Language WHERE Language > 0; DROP TABLE Language;

In this way i have a Filter Box like this

ENG

ESP

How can I change the language for the [closing_date.autoCalendar.Month] using this Filter Box?

Re: Multi-language months label

Or — Wed, 01 Dec 2021 15:24:48 GMT

I don't think you can do this for autocalendar fields, but I never use them so I'm not sure. Perhaps someone else who does use them can help...

Re: Multi-language months label

marco_lapolla — Thu, 02 Dec 2021 10:50:03 GMT

This is the only solution I found to solve my issue.
I added a new column called "month_number" and populated it with the month number.
MAIN TABLE and TRANSLATING TABLE are joined by month_number
TRANSLATING TABLE and LANGUAGE TABLE are joined by LANGUAGE

Does someone know a better way?

Re: Multi-language months label

Or — Thu, 02 Dec 2021 10:53:59 GMT

That is how I would approach it as well, and this avoids the autocalendar issue. Only difference for me is that I don't use a language table, I use a variable to determine which language to display (the process is largely the same as described here: https://community.qlik.com/t5/Qlik-Design-Blog/Making-a-Multilingual-Qlik-Sense-App/ba-p/1678131 )