??? Bizzare date modification behavior

[#1]

I have a question that is so simple it is baffling me.  I need someone external to tell me what I am doing wrong.

In QV 11 SR2, I am converting a date field using various qlikview functions like MonthName(), Quartername(), and WeekName().  When I show this function in a chart, the dimension values show properly.  All of the cyclic values show properly, the filtering through the dashboard.  When I place these filters in a multibox, the filtered, the values converted by the function are showing properly when a specific date is showed.  I do not have this issue when using the Month() and Week().  Let me show and example:

                                    Displayed                         Should Be

                                     -----------------------------------------------------------

Week End :                 1/9/2013                         1/9/2013

MonthName() :          Jun 2012                          Jan 2013

QuarterName() :        Jun - Augr 2012              Jan - Mar 2013

Year():                          2013                                2013

Any input is appreciated.

[sushil353]

Please upload the sample application.

[#3]

In your script, what's the date format?

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

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

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

[#4]

i'm having the exact same problem.  seems there's a bug with monthname() and quartername(), but just when used in a multibox or listbox.  when i but these expressions in a chart or textbox, they calculate correctly...

[Gysbert_Wassenaar]

Good catch! It looks like you're right. I can reproduce this in QV11.2 SR2. If these two functions are used in a listbox or multibox and only one value is selected then it seems to return the value based on the first date value in load order.

[campbellr]

Hi Guys

I'm glad I found this post, I was wondering why I was getting a rubbish date when filtering by one period date using the quartername and monthname functions.

My workaround has been to build the month or quarter names from month and year functions. I'm using QuarterStart and QuarterEnd but it's harder to get the sorting in the list to work as I'd like.

Ron