topic Re: Converting numbers to month in QlikView https://community.qlik.com/t5/QlikView/Converting-numbers-to-month/m-p/102611#M16293 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P></P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Month(MakeDate(1,Month)) as Month</P></BODY></HTML> Fri, 03 Aug 2018 10:53:30 GMT tresB 2018-08-03T10:53:30Z Converting numbers to month https://community.qlik.com/t5/QlikView/Converting-numbers-to-month/m-p/102610#M16292 <HTML><HEAD></HEAD><BODY><P>Hi all i have month i have month field it was shows numbers like</P><P>Month</P><P>1</P><P>2</P><P>3</P><P>4</P><P>5</P><P>6</P><P>7</P><P>8</P><P>9</P><P>10</P><P>11</P><P>12</P><P>it numbers convert to January,February,march.....</P><P>pls help me thanks in advance.</P></BODY></HTML> Fri, 03 Aug 2018 10:50:51 GMT https://community.qlik.com/t5/QlikView/Converting-numbers-to-month/m-p/102610#M16292 Anonymous 2018-08-03T10:50:51Z Re: Converting numbers to month https://community.qlik.com/t5/QlikView/Converting-numbers-to-month/m-p/102611#M16293 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P></P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Month(MakeDate(1,Month)) as Month</P></BODY></HTML> Fri, 03 Aug 2018 10:53:30 GMT https://community.qlik.com/t5/QlikView/Converting-numbers-to-month/m-p/102611#M16293 tresB 2018-08-03T10:53:30Z Re: Converting numbers to month https://community.qlik.com/t5/QlikView/Converting-numbers-to-month/m-p/102612#M16294 <HTML><HEAD></HEAD><BODY><P>not working bro</P></BODY></HTML> Fri, 03 Aug 2018 10:58:12 GMT https://community.qlik.com/t5/QlikView/Converting-numbers-to-month/m-p/102612#M16294 Anonymous 2018-08-03T10:58:12Z Re: Converting numbers to month https://community.qlik.com/t5/QlikView/Converting-numbers-to-month/m-p/102613#M16295 <HTML><HEAD></HEAD><BODY><P><EM>SET MonthNames='January;February;March;April;May;June;July;August;September;October;November;December';</EM></P><P></P><P><SPAN style="font-size: 13.3333px;"><EM><STRONG>Load</STRONG></EM></SPAN></P><P><STRONG><EM style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Month as MonthNum, </EM></STRONG></P><P><SPAN style="font-size: 13.3333px;"><EM><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Month(MakeDate(1,Month)) as Month</STRONG></EM></SPAN></P><P><SPAN style="font-size: 13.3333px;">;</SPAN></P><P><SPAN style="font-size: 13.3333px;">Load * Inline [</SPAN></P><P><SPAN style="font-size: 13.3333px;">Month</SPAN></P><P><SPAN style="font-size: 13.3333px;">1</SPAN></P><P><SPAN style="font-size: 13.3333px;">2</SPAN></P><P><SPAN style="font-size: 13.3333px;">3</SPAN></P><P><SPAN style="font-size: 13.3333px;">4</SPAN></P><P><SPAN style="font-size: 13.3333px;">5</SPAN></P><P><SPAN style="font-size: 13.3333px;">6</SPAN></P><P><SPAN style="font-size: 13.3333px;">7</SPAN></P><P><SPAN style="font-size: 13.3333px;">8</SPAN></P><P><SPAN style="font-size: 13.3333px;">9</SPAN></P><P><SPAN style="font-size: 13.3333px;">10</SPAN></P><P><SPAN style="font-size: 13.3333px;">11</SPAN></P><P><SPAN style="font-size: 13.3333px;">12];</SPAN></P><P><SPAN style="font-size: 13.3333px;"><IMG __jive_id="209812" alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/209812_Capture.JPG" style="height: auto;" /><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P></BODY></HTML> Fri, 03 Aug 2018 11:03:32 GMT https://community.qlik.com/t5/QlikView/Converting-numbers-to-month/m-p/102613#M16295 tresB 2018-08-03T11:03:32Z Re: Converting numbers to month https://community.qlik.com/t5/QlikView/Converting-numbers-to-month/m-p/102614#M16296 <HTML><HEAD></HEAD><BODY><P>LOAD</P><P></P><P></P><P> * INLINE [</P><P>&nbsp;&nbsp;&nbsp; Month</P><P>&nbsp;&nbsp;&nbsp; 1</P><P>&nbsp;&nbsp;&nbsp; 2</P><P>&nbsp;&nbsp;&nbsp; 3</P><P>&nbsp;&nbsp;&nbsp; 4</P><P>&nbsp;&nbsp;&nbsp; 5</P><P>&nbsp;&nbsp;&nbsp; 6</P><P>&nbsp;&nbsp;&nbsp; 7</P><P>&nbsp;&nbsp;&nbsp; 8</P><P>&nbsp;&nbsp;&nbsp; 9</P><P>&nbsp;&nbsp;&nbsp; 10</P><P>&nbsp;&nbsp;&nbsp; 11</P><P>&nbsp;&nbsp;&nbsp; 12</P><P>];</P><P>load Month(MakeDate(1,Month))as month</P></BODY></HTML> Fri, 03 Aug 2018 11:03:43 GMT https://community.qlik.com/t5/QlikView/Converting-numbers-to-month/m-p/102614#M16296 Anonymous 2018-08-03T11:03:43Z Re: Converting numbers to month https://community.qlik.com/t5/QlikView/Converting-numbers-to-month/m-p/102615#M16297 <HTML><HEAD></HEAD><BODY><P>its working </P><P>Thanks bro</P></BODY></HTML> Fri, 03 Aug 2018 11:08:46 GMT https://community.qlik.com/t5/QlikView/Converting-numbers-to-month/m-p/102615#M16297 Anonymous 2018-08-03T11:08:46Z