Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Qlikviewers,
I have got the following table:
DimTimeMonthly:
LOAD
Mid(MonthName,1,3) as Month
FROM
$(vPath_Reference_Data)DimTimeMonthly.qvd
(qvd)
;
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!!!
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.
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
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
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.