Month Multi-Language

chrisevans_cj — Wed, 25 Nov 2020 16:16:04 GMT

Good day,

I'm building a dashboard which needs to be in English, French and Portuguese.

What I'm looking for is to be able to have the correct MonthName for the language in a text box.

I.E:UPPER(DATE(TODAY()-1,'DD MMM YYYY')) returns 28 MAY 2017 perfectly for English, however I would need to have the month name displayed as for mai French or maio for Portuguese.

I have a list box in the document to change a variable vLanguage between EN, FR and PT. and have a load inline statement to link the various months and with DATE on master calendar.

MASTERCALENDAR: LOAD

DATE(DATE) AS DATE

,DAY(DATE) AS DAY

,WEEKDAY(DATE) AS WEEKDAY

,NUM(WEEKDAY(DATE)) AS WEEKDAYNUM

,WEEK(DATE) AS WEEK

,NUM(MONTH(DATE)) AS MONTH

,WEEK(DATE) &'-'& NUM(WEEKDAY(DATE)) AS [WEEK-DAY]

,DAYNUMBEROFYEAR(DATE) AS [DAYNUMBER]

,'Q' & CEIL(MONTH(DATE) / 3) AS QUARTER

,YEAR(DATE) AS YEAR;

LOAD DATE(MIN + ITERNO()) AS DATE ,MAX WHILE MIN + ITERNO() <= MAX;

LOAD MIN(FIELDVALUE('DATE', RECNO()))-1 AS MIN, MAX(FIELDVALUE('DATE', RECNO())) AS MAX AUTOGENERATE FIELDVALUECOUNT('DATE');

LOAD *

INLINE [

MONTH,vLanguage,MonthName,Language

1,FR,janv,French

2,FR,févr,French

3,FR,mars,French

4,FR,avril,French

5,FR,mai,French

6,FR,juin,French

7,FR,juil,French

8,FR,août,French

9,FR,sept,French

10,FR,oct,French

11,FR,nov,French

12,FR,déc,French

1,EN,Jan,English

2,EN,Feb,English

3,EN,Mar,English

4,EN,Apr,English

5,EN,May,English

6,EN,Jun,English

7,EN,Jul,English

8,EN,Aug,English

9,EN,Sep,English

10,EN,Oct,English

11,EN,Nov,English

12,EN,Dec,English

1,PT,jan,Portuguese

2,PT,fev,Portuguese

3,PT,março,Portuguese

4,PT,abril,Portuguese

5,PT,maio,Portuguese

6,PT,junho,Portuguese

7,PT,julho,Portuguese

8,PT,agosto,Portuguese

9,PT,set,Portuguese

10,PT,out,Portuguese

11,PT,nov,Portuguese

12,PT,dez,Portuguese

];

But I need a way to have the correct Month name shown when the vLanguage is changed. Any ideas?

Re: Month Multi-Language

migueldelval — Mon, 29 May 2017 12:21:43 GMT

Hi Chris,

Please check attached file.

Regards

Miguel del Valle

Re: Month Multi-Language

chrisevans_cj — Mon, 29 May 2017 12:27:00 GMT

Hi Miguel,

I've added a text box which is what I'm looking to have the dynamic change when the language is changed.

Do you have any ideas on that?

Re: Month Multi-Language

RonaldDoes — Mon, 29 May 2017 12:53:10 GMT

Hi Chris,

How about this?

=Date(Today(), 'DD ') & 
Only({<MONTH = {$(=Date(Today(),'M'))}>}MonthName)  &
Date(Today(), ' YYYY')

Re: Month Multi-Language

chrisevans_cj — Mon, 29 May 2017 13:54:25 GMT

Thanks Ronald - that's the solution

Re: Month Multi-Language

chrisevans_cj — Fri, 27 Oct 2017 11:27:24 GMT

Almost there - works for the majority of cases. I now need to get FirstSortedValue(RELEASENUMBER, -DATECREATED) to ingore a field called product - any ideas on that one?

topic Re: Month Multi-Language in QlikView

Month Multi-Language

Re: Month Multi-Language

Re: Month Multi-Language

Re: Month Multi-Language

Re: Month Multi-Language

Re: Month Multi-Language