topic set monthname multi langauge? in QlikView

set monthname multi langauge?

Thu, 22 Apr 2010 14:56:26 GMT

I have a set Monthname in Dutch

SET MonthNames='jan;feb;mrt;apr;mei;jun;jul;aug;sep;okt;nov;dec';

I have multi language and when I select Eng MonthNames must change in to

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

Can you help me?

set monthname multi langauge?

Anonymous — Thu, 22 Apr 2010 15:17:38 GMT

If it's OK to change settings before reload, you can use a variable vLanguage with possible values 'English'. 'Dutch', etc., and check its value in the script. Depending on value, use differrent SET MonthName statements.
Certainly all users of the document will see the same language wich was selected before reload. If this is not acceptable, there solution will be more complex. For example, you have to keep multiple month fields and show them depending on language.

set monthname multi langauge?

Thu, 22 Apr 2010 15:55:48 GMT

I want it after the reload. If you select then a language you see the monthname in that language

set monthname multi langauge?

Anonymous — Thu, 22 Apr 2010 16:12:00 GMT

In this case you have to keep Months in all languages you use, for example Month_E and Month_D. How to show them is up to you. There could be conditional show of objects with different Month fields depending on vLanguage variable, or calculated dimension in each object, like
if(vLanguage='English', Month_E, Month_D).

set monthname multi langauge?

johnw — Fri, 23 Apr 2010 01:21:41 GMT

Here's one approach:

[Language Month Table]:
LOAD *
,mod(recno()-1,12)+1 as Month
;
LOAD
Language
,subfield(MonthNames,';') as MonthName
INLINE [
Language, MonthNames
Dutch,jan;feb;mrt;apr;mei;jun;jul;aug;sep;okt;nov;dec
English,Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec
];

See attached for it in use.

set monthname multi langauge?

Fri, 23 Apr 2010 08:56:53 GMT

thx it is working

Re: set monthname multi langauge?

Wed, 13 Mar 2013 12:51:49 GMT

Hello,

I tried to use this solution for months and it's working fine on charts, but when I try to create list box I get all of the values in every language available on the filter. When I choose one of the languages I get its monthnames at top and the other language's months appears as well (with gray background as they're not selected). How to get rid of them and show only the values for selected language?

Re: set monthname multi langauge?

Anonymous — Thu, 14 Mar 2013 20:35:37 GMT

You can use option "Hide Excluded" in your listbox, or use calculated list box with "if" or "set" condition.

Re: set monthname multi langauge?

pavandhananjaya — Thu, 01 Aug 2019 07:14:21 GMT

Hi,

I am not able to access your qvw file. Since I'm using qlik sense. Could you please post your expression(how to use) to translate months here ?