Multi-language months label

[marco_lapolla]

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?

[Or]

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

[marco_lapolla]

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?

 

[Or]

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...

[marco_lapolla]

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?

[Or]

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 )