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:
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:
I would try another approach. Please take a look (or two) into my example app. Don't hesitate to ask for details, if necessary.
Independent of the concept you will use: I recognized that all your tables where singles. In most cases this is not the best approach. Check out the possibilities of linking tables together via uniqe keys. (Or second: the QV-Joins)
Thanks for the reply Roland, but I see that you are using pre calculated fields using the load script, since it is about localizing dates, there is a problem of doing that, since depending on the user's time zone, a specific month or day, cannot be pre calculated, since, (GMT +- X) can fall on many days or months, that's why I was trying to use a runtime solution.