Change values from the script (if, case statement)

[#1]

Hello Qlikviewers,

I have got the following table:

DimTimeMonthly:
LOAD
Mid(MonthName,1,3) as Month

FROM
$(vPath_Reference_Data)DimTimeMonthly.qvd
(qvd)

;

Feb

Month
Jan
Mar
Apr

I was asked to introduce a slider in the QVW the months in spanish:

ENE... Feb.. Mar.... ABR

How can I change the values of the field from the script???

Thanks!!!

[giakoum]

There is a set command for that :

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

Change them to Spanish

[marcus_sommer]

If you don't want to be set the spanish values as default - have a look here: http://community.qlik.com/blogs/qlikviewdesignblog/2012/11/30/handling-multiple-languages

If you it only need at a few points an approach with pick(match('Jan', ...), 'ENE', ...) could be easier.

- Marcus

[#4 · Accepted solution]

Marcus and Ioannis,

Thank you for your help...

I figure other way to do it:

In the slide, in stead of choosing the field, i made an expression

=If(Month='Jan','Ene',
if(Month='Feb','Feb',
if(Month='Mar','Mar',
if(Month='Apr','Abr',
if(Month='May','May',
if(Month='Jun','Jun',
if(Month='Jul','Jul',
if(Month='Aug','Ago',
if(Month='Sep','Sep',
if(Month='Oct','Oct',
if(Month='Nov','Nov',
'Dec'
)
)
)))))))))

It was a bit too much but it solved the problem.