MonthName() behavior difference

Tue, 22 Dec 2009 16:16:07 GMT

Hi,

8.50.6091.4			8.50.6231.5
CallNo	Date	Period	CallNo	Date	Period
1	1-Dec-09	Dec-09	1	1-Dec-09	Dec-09
2		Dec-09	2
3	2-Jan-09	Jan-09	3	2-Jan-09	Jan-09
4		Jan-09	4
5		Jan-09	5

As you can see above, in 8.50.6091.4, MonthName(Date) is giving the value for Period even for the records where no Date is mentioned. It is taking the Date value encountered with previous record and carry on with that until any Not-Null value in Date field.

It means if we are showing the Period Wise No. of Closed Calls, we will be giving a wrong count.

With 8.50.6231.5, it is corrected i think.

topic MonthName() behavior difference in QlikView

MonthName() behavior difference