topic Re: help with Expression in QlikView https://community.qlik.com/t5/QlikView/help-with-Expression/m-p/1194006#M385451 <HTML><HEAD></HEAD><BODY><P>No problemo <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 12 Oct 2016 21:22:37 GMT sunny_talwar 2016-10-12T21:22:37Z help with Expression https://community.qlik.com/t5/QlikView/help-with-Expression/m-p/1194003#M385448 <HTML><HEAD></HEAD><BODY><P> Date(Date#(left(subfield(FileName("AB_CD_EF_GH_IJ_KL_Monthly_SEPTEMBER_2016.xlsx"),'_',8),8),'MMMYYYY'),'MMM YYYY')</P><P></P><P>i'm trying to generate new field&nbsp; from a above file name , which&nbsp; should have sept 2016 as value. my expression throws error . can somebody help me here .</P></BODY></HTML> Wed, 12 Oct 2016 20:30:42 GMT https://community.qlik.com/t5/QlikView/help-with-Expression/m-p/1194003#M385448 arusanah 2016-10-12T20:30:42Z Re: help with Expression https://community.qlik.com/t5/QlikView/help-with-Expression/m-p/1194004#M385449 <HTML><HEAD></HEAD><BODY><P>Try this may be:</P><P></P><P><STRONG>=MonthName(Date#(Capitalize(</STRONG></P><P><STRONG>Subfield('AB_CD_EF_GH_IJ_KL_Monthly_SEPTEMBER_2016.xlsx', '_', 8)) &amp; '-' &amp; </STRONG></P><P><STRONG>SubField(Subfield('AB_CD_EF_GH_IJ_KL_Monthly_SEPTEMBER_2016.xlsx', '_', 9), '.', 1), 'MMMM-YYYY'))</STRONG></P><P></P><P>Or</P><P></P><P></P><P><STRONG>=MonthName(Date#(Capitalize(</STRONG></P><P><STRONG>Subfield(FileName(), '_', 8)) &amp; '-' &amp; </STRONG></P><P><STRONG>SubField(Subfield(FileName(), '_', 9), '.', 1), 'MMMM-YYYY'))</STRONG></P></BODY></HTML> Wed, 12 Oct 2016 20:36:55 GMT https://community.qlik.com/t5/QlikView/help-with-Expression/m-p/1194004#M385449 sunny_talwar 2016-10-12T20:36:55Z Re: help with Expression https://community.qlik.com/t5/QlikView/help-with-Expression/m-p/1194005#M385450 <HTML><HEAD></HEAD><BODY><P>Thank you Sunny <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> !!!</P></BODY></HTML> Wed, 12 Oct 2016 21:21:25 GMT https://community.qlik.com/t5/QlikView/help-with-Expression/m-p/1194005#M385450 arusanah 2016-10-12T21:21:25Z Re: help with Expression https://community.qlik.com/t5/QlikView/help-with-Expression/m-p/1194006#M385451 <HTML><HEAD></HEAD><BODY><P>No problemo <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 12 Oct 2016 21:22:37 GMT https://community.qlik.com/t5/QlikView/help-with-Expression/m-p/1194006#M385451 sunny_talwar 2016-10-12T21:22:37Z