how to display multiple language for Month field ?

[#1]

Hi All,

It has month field shows "Jan, Feb, Mar..." in list box and 1,2,3... in excel file. I try to show it with two I language(EN, CN) , so I create one table in script
LOAD * INLINE [
Month , MonthCN
1 , ??
2 , ??
.....
]
and run macro . When I select CN, it shows "??, ??....", but select "EN", it shows "1,2,3..." , how can I do that it shows "Jan, Feb, Mar..." when I select "EN" ?

Thanks in advance ,

henrywang

[disqr_rm]

Hi, Did you try this post http://community.qlik.com/forums/t/16308.aspx

Would that help you?

[#3]

I have read it but it's not Key to this question, I can display multiple language for other fields , the thing is to how change "1,2,3...." into "Jan, Feb, Mar...." ?