topic ??? Bizzare date modification behavior in QlikView

??? Bizzare date modification behavior

Fri, 08 Mar 2013 13:55:30 GMT

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.

Re: ??? Bizzare date modification behavior

sushil353 — Fri, 15 Mar 2013 03:26:00 GMT

Please upload the sample application.

Re: ??? Bizzare date modification behavior

Fri, 15 Mar 2013 04:54:00 GMT

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';

Re: ??? Bizzare date modification behavior

Fri, 24 May 2013 16:01:22 GMT

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...

Re: ??? Bizzare date modification behavior

Gysbert_Wassenaar — Fri, 24 May 2013 17:11:18 GMT

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.

Re: ??? Bizzare date modification behavior

campbellr — Thu, 03 Apr 2014 02:32:50 GMT

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