topic Month Number in QlikView https://community.qlik.com/t5/QlikView/Month-Number/m-p/1139072#M900570 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have one field </P><P></P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; MonthFrench</P><P>&nbsp;&nbsp;&nbsp; janvier</P><P>&nbsp;&nbsp;&nbsp; février</P><P>&nbsp;&nbsp;&nbsp; mars</P><P>&nbsp;&nbsp;&nbsp; avril</P><P>&nbsp;&nbsp;&nbsp; mai</P><P>&nbsp;&nbsp;&nbsp; juin</P><P>&nbsp;&nbsp;&nbsp; juillet</P><P>&nbsp;&nbsp;&nbsp; août</P><P>&nbsp;&nbsp;&nbsp; septembre</P><P>&nbsp;&nbsp;&nbsp; octobre</P><P>&nbsp;&nbsp;&nbsp; novembre</P><P>&nbsp;&nbsp;&nbsp; décembre</P><P>];</P><P></P><P>So, here i want to show number 1,2,3,4,....12 in list box. How?</P><P></P><P>If i use this </P><P></P><P>if(MonthFrench='janvier',1,</P><P>//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(MonthFrench='février',2,</P><P>//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(MonthFrench='mars',3,</P><P>//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(MonthFrench='avril',4,</P><P>//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(MonthFrench='mai',5,</P><P>//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(MonthFrench='juin',6,</P><P>//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(MonthFrench='juillet',7,</P><P>//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(MonthFrench='août',8,</P><P>//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(MonthFrench='septembre',9,</P><P>//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(MonthFrench='octobre',10,</P><P>//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(MonthFrench='novembre',11,</P><P>//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(MonthFrench='décembre',12))))))))))))</P><P></P><P>It will come, But i want to see only these values instead of Name months</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anil_Babu_Samineni 2020-11-25T16:16:04Z Month Number https://community.qlik.com/t5/QlikView/Month-Number/m-p/1139072#M900570 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have one field </P><P></P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; MonthFrench</P><P>&nbsp;&nbsp;&nbsp; janvier</P><P>&nbsp;&nbsp;&nbsp; février</P><P>&nbsp;&nbsp;&nbsp; mars</P><P>&nbsp;&nbsp;&nbsp; avril</P><P>&nbsp;&nbsp;&nbsp; mai</P><P>&nbsp;&nbsp;&nbsp; juin</P><P>&nbsp;&nbsp;&nbsp; juillet</P><P>&nbsp;&nbsp;&nbsp; août</P><P>&nbsp;&nbsp;&nbsp; septembre</P><P>&nbsp;&nbsp;&nbsp; octobre</P><P>&nbsp;&nbsp;&nbsp; novembre</P><P>&nbsp;&nbsp;&nbsp; décembre</P><P>];</P><P></P><P>So, here i want to show number 1,2,3,4,....12 in list box. How?</P><P></P><P>If i use this </P><P></P><P>if(MonthFrench='janvier',1,</P><P>//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(MonthFrench='février',2,</P><P>//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(MonthFrench='mars',3,</P><P>//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(MonthFrench='avril',4,</P><P>//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(MonthFrench='mai',5,</P><P>//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(MonthFrench='juin',6,</P><P>//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(MonthFrench='juillet',7,</P><P>//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(MonthFrench='août',8,</P><P>//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(MonthFrench='septembre',9,</P><P>//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(MonthFrench='octobre',10,</P><P>//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(MonthFrench='novembre',11,</P><P>//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(MonthFrench='décembre',12))))))))))))</P><P></P><P>It will come, But i want to see only these values instead of Name months</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Month-Number/m-p/1139072#M900570 Anil_Babu_Samineni 2020-11-25T16:16:04Z Re: Month Number https://community.qlik.com/t5/QlikView/Month-Number/m-p/1139073#M900571 <HTML><HEAD></HEAD><BODY><P>How about this:</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>LOAD *,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">RowNo() as MonthNum</SPAN></STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>INLINE [</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>&nbsp;&nbsp;&nbsp; MonthFrench</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>&nbsp;&nbsp;&nbsp; janvier</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>&nbsp;&nbsp;&nbsp; février</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>&nbsp;&nbsp;&nbsp; mars</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>&nbsp;&nbsp;&nbsp; avril</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>&nbsp;&nbsp;&nbsp; mai</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>&nbsp;&nbsp;&nbsp; juin</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>&nbsp;&nbsp;&nbsp; juillet</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>&nbsp;&nbsp;&nbsp; août</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>&nbsp;&nbsp;&nbsp; septembre</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>&nbsp;&nbsp;&nbsp; octobre</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>&nbsp;&nbsp;&nbsp; novembre</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>&nbsp;&nbsp;&nbsp; décembre</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>];</STRONG></P></BODY></HTML> Tue, 12 Jul 2016 12:13:33 GMT https://community.qlik.com/t5/QlikView/Month-Number/m-p/1139073#M900571 sunny_talwar 2016-07-12T12:13:33Z Re: Month Number https://community.qlik.com/t5/QlikView/Month-Number/m-p/1139074#M900572 <HTML><HEAD></HEAD><BODY><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14683256507227879" jivemacro_uid="_14683256507227879"> <P>=num(Month(DateField))</P> </PRE><P></P><P>Month is a dual function. It contains the text and the numerical value.</P></BODY></HTML> Tue, 12 Jul 2016 12:14:25 GMT https://community.qlik.com/t5/QlikView/Month-Number/m-p/1139074#M900572 MindaugasBacius 2016-07-12T12:14:25Z Re: Month Number https://community.qlik.com/t5/QlikView/Month-Number/m-p/1139075#M900573 <HTML><HEAD></HEAD><BODY><P>I have only Month Field in that what i need to do. If i am doing mapping getting error</P></BODY></HTML> Tue, 12 Jul 2016 12:17:52 GMT https://community.qlik.com/t5/QlikView/Month-Number/m-p/1139075#M900573 Anil_Babu_Samineni 2016-07-12T12:17:52Z Re: Month Number https://community.qlik.com/t5/QlikView/Month-Number/m-p/1139076#M900574 <HTML><HEAD></HEAD><BODY><P>What is your exact script?</P></BODY></HTML> Tue, 12 Jul 2016 12:20:08 GMT https://community.qlik.com/t5/QlikView/Month-Number/m-p/1139076#M900574 sunny_talwar 2016-07-12T12:20:08Z Re: Month Number https://community.qlik.com/t5/QlikView/Month-Number/m-p/1139077#M900575 <HTML><HEAD></HEAD><BODY><P>Nothing there, In my script i have like below</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">LOAD * </STRONG><STRONG style="font-style: inherit; font-family: inherit;">INLINE [</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; MonthFrench</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; janvier</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; février</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; mars</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; avril</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; mai</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; juin</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; juillet</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; août</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; septembre</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; octobre</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; novembre</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; décembre</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">];</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;"><BR /></STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">Expected output is</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;"><BR /></STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">Listbox</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">1</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">2</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">3</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">4</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">5</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">6</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">7</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">8</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">9</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">10</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">11</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">12<BR /></STRONG></P></BODY></HTML> Tue, 12 Jul 2016 12:21:46 GMT https://community.qlik.com/t5/QlikView/Month-Number/m-p/1139077#M900575 Anil_Babu_Samineni 2016-07-12T12:21:46Z Re: Month Number https://community.qlik.com/t5/QlikView/Month-Number/m-p/1139078#M900576 <HTML><HEAD></HEAD><BODY><P>Use <A _jive_internal="true" data-avatarid="10792" data-externalid="" data-online="false" data-presence="null" data-userid="171708" data-username="stalwar1" href="https://community.qlik.com/people/stalwar1" style="font-weight: bold; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #8b8b8b; background-color: #f2f2f2;">Sunny T</A> suggestion.</P><P>In the List Object look for MonthNum.</P><P></P><P>If you are doing some mapping or so let us now.</P></BODY></HTML> Tue, 12 Jul 2016 12:24:15 GMT https://community.qlik.com/t5/QlikView/Month-Number/m-p/1139078#M900576 MindaugasBacius 2016-07-12T12:24:15Z Re: Month Number https://community.qlik.com/t5/QlikView/Month-Number/m-p/1139079#M900577 <HTML><HEAD></HEAD><BODY><P>Like this, right?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/130981_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 12 Jul 2016 12:24:26 GMT https://community.qlik.com/t5/QlikView/Month-Number/m-p/1139079#M900577 sunny_talwar 2016-07-12T12:24:26Z Re: Month Number https://community.qlik.com/t5/QlikView/Month-Number/m-p/1139080#M900578 <HTML><HEAD></HEAD><BODY><P>Do i need to change name, If i want to show same name of the field</P><P></P><P>Like below, Is this possible</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">LOAD *,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #ff0000;">RowNo() as <STRONG style="color: #3d3d3d; font-family: inherit; font-size: 13px; font-style: inherit;">MonthFrench</STRONG></SPAN></STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">INLINE [</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; MonthFrench</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; janvier</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; février</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; mars</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; avril</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; mai</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; juin</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; juillet</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; août</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; septembre</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; octobre</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; novembre</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; décembre</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">];</STRONG></P></BODY></HTML> Tue, 12 Jul 2016 12:27:16 GMT https://community.qlik.com/t5/QlikView/Month-Number/m-p/1139080#M900578 Anil_Babu_Samineni 2016-07-12T12:27:16Z Re: Month Number https://community.qlik.com/t5/QlikView/Month-Number/m-p/1139081#M900579 <HTML><HEAD></HEAD><BODY><P>If you want to replace MonthFrench, then may be this:</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>LOAD <SPAN style="color: #ff0000;">MonthFrench as MonthName,</SPAN></STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RowNo() <SPAN style="color: #ff0000;">as MonthFrench</SPAN></STRONG></P><P><STRONG>INLINE [</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; MonthFrench</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; janvier</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; février</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; mars</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; avril</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; mai</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; juin</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; juillet</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; août</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; septembre</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; octobre</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; novembre</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; décembre</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>];</STRONG></P></BODY></HTML> Tue, 12 Jul 2016 12:29:27 GMT https://community.qlik.com/t5/QlikView/Month-Number/m-p/1139081#M900579 sunny_talwar 2016-07-12T12:29:27Z Re: Month Number https://community.qlik.com/t5/QlikView/Month-Number/m-p/1139082#M900580 <HTML><HEAD></HEAD><BODY><P>Sunny, Thanks i am fetching data from Database.</P><P></P><P>I have one field which is Date</P><P></P><P>Now i change to month(Date)</P><P></P><P>Here, I need to apply that How to do that?</P></BODY></HTML> Tue, 12 Jul 2016 12:44:20 GMT https://community.qlik.com/t5/QlikView/Month-Number/m-p/1139082#M900580 Anil_Babu_Samineni 2016-07-12T12:44:20Z Re: Month Number https://community.qlik.com/t5/QlikView/Month-Number/m-p/1139083#M900581 <HTML><HEAD></HEAD><BODY><P>Try using <A href="https://community.qlik.com/people/mindaugasbacius">mindaugasbacius</A>‌'s logic here:</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Num(Month(Date)) as MonthFrench</STRONG></SPAN></P></BODY></HTML> Tue, 12 Jul 2016 12:46:23 GMT https://community.qlik.com/t5/QlikView/Month-Number/m-p/1139083#M900581 sunny_talwar 2016-07-12T12:46:23Z Re: Month Number https://community.qlik.com/t5/QlikView/Month-Number/m-p/1139084#M900582 <HTML><HEAD></HEAD><BODY><P>Ok, Majorly i am looking Inline. In future, i want to know. Any way, </P><P></P><P>Thanks Miindaugas &amp; Sunny</P></BODY></HTML> Tue, 12 Jul 2016 12:52:18 GMT https://community.qlik.com/t5/QlikView/Month-Number/m-p/1139084#M900582 Anil_Babu_Samineni 2016-07-12T12:52:18Z