topic Re: Converting Month Numbers Shows only Jan and Dec in QlikView https://community.qlik.com/t5/QlikView/Converting-Month-Numbers-Shows-only-Jan-and-Dec/m-p/1421890#M801262 <HTML><HEAD></HEAD><BODY><P>Try this instead</P><P></P><P><STRONG>Month(Date#(ActBillMo, 'M')) as ActBillMo</STRONG></P></BODY></HTML> Mon, 04 Dec 2017 14:12:11 GMT sunny_talwar 2017-12-04T14:12:11Z Converting Month Numbers Shows only Jan and Dec https://community.qlik.com/t5/QlikView/Converting-Month-Numbers-Shows-only-Jan-and-Dec/m-p/1421887#M801259 <HTML><HEAD></HEAD><BODY><P>We are using SQL to pull the month, which then gets loaded into Qlikview as the month number. When I try converting these to month name In Qlikview it will only show January and December even though all calendar months should be there. Do you know what is causing this?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Converting-Month-Numbers-Shows-only-Jan-and-Dec/m-p/1421887#M801259 greend21 2020-11-25T16:16:04Z Re: Converting Month Numbers Shows only Jan and Dec https://community.qlik.com/t5/QlikView/Converting-Month-Numbers-Shows-only-Jan-and-Dec/m-p/1421888#M801260 <HTML><HEAD></HEAD><BODY><P>Can you show the month number field you get from SQL? and also, what do you do to convert it? I mean what script do you use?</P></BODY></HTML> Mon, 04 Dec 2017 14:05:58 GMT https://community.qlik.com/t5/QlikView/Converting-Month-Numbers-Shows-only-Jan-and-Dec/m-p/1421888#M801260 sunny_talwar 2017-12-04T14:05:58Z Re: Converting Month Numbers Shows only Jan and Dec https://community.qlik.com/t5/QlikView/Converting-Month-Numbers-Shows-only-Jan-and-Dec/m-p/1421889#M801261 <HTML><HEAD></HEAD><BODY><P></P><P>MONTH(actual_bill_date) ActBillMo is the SQL line which results in the 1-12 numbers.</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">Month</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">ActBillMo</SPAN><SPAN style="font-size: 8pt;">) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">ActBillMo </SPAN> returns only Jan &amp; Dec</P></BODY></HTML> Mon, 04 Dec 2017 14:11:13 GMT https://community.qlik.com/t5/QlikView/Converting-Month-Numbers-Shows-only-Jan-and-Dec/m-p/1421889#M801261 greend21 2017-12-04T14:11:13Z Re: Converting Month Numbers Shows only Jan and Dec https://community.qlik.com/t5/QlikView/Converting-Month-Numbers-Shows-only-Jan-and-Dec/m-p/1421890#M801262 <HTML><HEAD></HEAD><BODY><P>Try this instead</P><P></P><P><STRONG>Month(Date#(ActBillMo, 'M')) as ActBillMo</STRONG></P></BODY></HTML> Mon, 04 Dec 2017 14:12:11 GMT https://community.qlik.com/t5/QlikView/Converting-Month-Numbers-Shows-only-Jan-and-Dec/m-p/1421890#M801262 sunny_talwar 2017-12-04T14:12:11Z