Hi everyone, for the past couple of days I have been working, mostly trying to create a function that will allow me to localize some dates, there are a couple of threads that I started regarding some bug QlikView has, if you have some spare time, go ahead and take a look at them:
The problem is, the system variables:
Can be modified in runtime, but their new value won't be reflected on the expression and date formats that use them like the following:
WWW, MMM D, YYYY = Wed, Nov 24, 2010
So I created a couple of tables DayNames and MonthNames, also a third one called Languages, as you can imagine, the data is linked by Language to each name:
If you find weird the value inside the column MonthName and DayName, that includes both Locale_<VALUE> its because there is another weird behavior with QV that if I have the same value in a column, the functions FieldValue goes crazy, but that's another story.
I did create a function that returned the date as I wanted, here's the code:
Num(weekday($1)) & '_'& GetFieldSelections(Locale)
&', ' &
,Num(Month($1)) & '_'& GetFieldSelections(Locale)
//Delimiter&' ' &
&', ' &
So far everything was going fine, but when I called it from the calendar:
It does display the dates as I wanted:
But now I am stuck, since after I choose the desired date, the calendar goes blank.
After some testing I see that I selects all the Languages after selecting a date, but why?
Please, any suggestion on how to implement this, or make it to work, as for displaying dates accordingly to the selected language, will be very much appreciated.
Thanks in advance for the time.
dateTest3.qvw 164.5 K