topic Re: My month_n script is not working ? in QlikView https://community.qlik.com/t5/QlikView/My-month-n-script-is-not-working/m-p/2188#M609034 <HTML><HEAD></HEAD><BODY><P>Hi Anil</P><P></P><P>Thank you</P><P></P><P>Paul</P></BODY></HTML> Wed, 17 Jan 2018 15:11:12 GMT paulyeo11 2018-01-17T15:11:12Z My month_n script is not working ? https://community.qlik.com/t5/QlikView/My-month-n-script-is-not-working/m-p/2185#M609031 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">Hi All</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">I have below script work fine :-</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">SubField([Expected Close Date],'-' ,3) as Year,</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Now i need to create month_n field :- </SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">(year(today()) - year(@50:60T)) * 12 + month(today()) - month(@50:60T) + 1 as Month_n,</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">But above script return no value.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">The purpose of month_n is allow me select </SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">month_n = 0 , that is current month. </SPAN></P><P><SPAN style="font-size: 13.3333px;">month_n = 1 , that is Next month</SPAN></P><P><SPAN style="font-size: 13.3333px;">etc</SPAN></P><P><SPAN style="font-size: 13.3333px;">. </SPAN></P><P><SPAN style="font-size: 13.3333px;">Can some one help me.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Paul</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; </SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; </SPAN></P></BODY></HTML> Wed, 17 Jan 2018 13:22:47 GMT https://community.qlik.com/t5/QlikView/My-month-n-script-is-not-working/m-p/2185#M609031 paulyeo11 2018-01-17T13:22:47Z Re: My month_n script is not working ? https://community.qlik.com/t5/QlikView/My-month-n-script-is-not-working/m-p/2186#M609032 <HTML><HEAD></HEAD><BODY><P>My QVW</P></BODY></HTML> Wed, 17 Jan 2018 13:23:57 GMT https://community.qlik.com/t5/QlikView/My-month-n-script-is-not-working/m-p/2186#M609032 paulyeo11 2018-01-17T13:23:57Z Re: My month_n script is not working ? https://community.qlik.com/t5/QlikView/My-month-n-script-is-not-working/m-p/2187#M609033 <HTML><HEAD></HEAD><BODY><P>Try this?</P><P></P><P><STRONG>=(year(today()) - year(Date#(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">[Expected Close Date]</SPAN>,'MM-DD-YYYY'))) * 12 + month(today()) - month(Date#(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">[Expected Close Date]</SPAN>,'MM-DD-YYYY')) + 1 as Month_n</STRONG></P></BODY></HTML> Wed, 17 Jan 2018 15:05:57 GMT https://community.qlik.com/t5/QlikView/My-month-n-script-is-not-working/m-p/2187#M609033 Anil_Babu_Samineni 2018-01-17T15:05:57Z Re: My month_n script is not working ? https://community.qlik.com/t5/QlikView/My-month-n-script-is-not-working/m-p/2188#M609034 <HTML><HEAD></HEAD><BODY><P>Hi Anil</P><P></P><P>Thank you</P><P></P><P>Paul</P></BODY></HTML> Wed, 17 Jan 2018 15:11:12 GMT https://community.qlik.com/t5/QlikView/My-month-n-script-is-not-working/m-p/2188#M609034 paulyeo11 2018-01-17T15:11:12Z