topic How to generate Month Names in QlikView

How to generate Month Names

Anonymous — Tue, 23 Dec 2014 18:35:39 GMT

I want Monthnames to show only Jan, Feb etc....Its showing Jan 2011, Feb 2011 as of now as shown in the image below.

This is my current script below:

let start = floor(date(AddMonths('2013-12-31',-35)));

let end = floor(date('2013-12-31'));

let numofdays = end - start+1;

Time_table:

LOAD

Distinct

AutoNumberHash128(MonthName(date($(start)+ RowNo() -1))) as Month_Seq,

This is my current script. Thanks

MonthName(date($(start)+ RowNo() -1)) as Month_name,

YearName(date($(start)+ RowNo() -1)) as Year,

date($(start)+ RowNo() -1)as Date

AutoGenerate $(numofdays);

Re: How to generate Month Names

Anonymous — Tue, 23 Dec 2014 18:38:58 GMT

Try using the Month() function instead of MonthName()

Re: How to generate Month Names

Anonymous — Tue, 23 Dec 2014 18:50:27 GMT

Thanks Bill.

here is the correct complete syntax:

1) Month(date($(start)+ RowNo() -1)) as Month,

2) Monthname(date($(start)+ RowNo() -1)) as Month_name,

1) will display Jan and 2 will Jan 2011.

Re: How to generate Month Names

its_anandrjs — Tue, 23 Dec 2014 18:51:50 GMT

Yes you are right see this also

let start = floor(date(AddMonths('2013-12-31',-35)));
let end = floor(date('2013-12-31'));
let numofdays = end - start+1;

LOAD
Distinct
AutoNumberHash128(MonthName(date($(start)+ RowNo() -1))) as Month_Seq,
MonthName(date($(start)+ RowNo() -1)) as Month_name,
Month(date($(start)+ RowNo() -1)) as Months,
YearName(date($(start)+ RowNo() -1)) as Year,
date($(start)+ RowNo() -1)as Date
AutoGenerate $(numofdays);

Regards

Anand