topic Re: Need help in expression in QlikView https://community.qlik.com/t5/QlikView/Need-help-in-expression/m-p/356643#M132344 <HTML><HEAD></HEAD><BODY><P>Perhaps just this?</P><P></P><PRE __default_attr="xml" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13400032150006182" jivemacro_uid="_13400032150006182"><P>=MonthName(AddMonths(today(),-1))&amp;' Sales'</P></PRE></BODY></HTML> Mon, 18 Jun 2012 07:06:57 GMT 2012-06-18T07:06:57Z Need help in expression https://community.qlik.com/t5/QlikView/Need-help-in-expression/m-p/356642#M132343 <HTML><HEAD></HEAD><BODY><P>Hello Friends,</P><P></P><P>In a straight table, I have expression and I would like to have a Label like the following&nbsp; =(MonthName(AddMonths(today(),-1)), 'Sales') like <STRONG>June 2012 Sales</STRONG>.</P><P></P><P>Can any one advise me..</P><P></P><P>Regards</P><P></P><P>Chriss</P></BODY></HTML> Mon, 18 Jun 2012 07:03:53 GMT https://community.qlik.com/t5/QlikView/Need-help-in-expression/m-p/356642#M132343 2012-06-18T07:03:53Z Re: Need help in expression https://community.qlik.com/t5/QlikView/Need-help-in-expression/m-p/356643#M132344 <HTML><HEAD></HEAD><BODY><P>Perhaps just this?</P><P></P><PRE __default_attr="xml" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13400032150006182" jivemacro_uid="_13400032150006182"><P>=MonthName(AddMonths(today(),-1))&amp;' Sales'</P></PRE></BODY></HTML> Mon, 18 Jun 2012 07:06:57 GMT https://community.qlik.com/t5/QlikView/Need-help-in-expression/m-p/356643#M132344 2012-06-18T07:06:57Z Re: Need help in expression https://community.qlik.com/t5/QlikView/Need-help-in-expression/m-p/356644#M132345 <HTML><HEAD></HEAD><BODY><P>Hi Chris,</P><P></P><P>You should set something similar to this.</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13400032606951426" jivemacro_uid="_13400032606951426"><P>=MonthName(AddMonths(today(),-1)) &amp; ' Sales'</P></PRE><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Mon, 18 Jun 2012 07:07:39 GMT https://community.qlik.com/t5/QlikView/Need-help-in-expression/m-p/356644#M132345 Miguel_Angel_Baeyens 2012-06-18T07:07:39Z Re: Need help in expression https://community.qlik.com/t5/QlikView/Need-help-in-expression/m-p/356645#M132346 <HTML><HEAD></HEAD><BODY><P>Thanks Robert......</P></BODY></HTML> Mon, 18 Jun 2012 07:08:18 GMT https://community.qlik.com/t5/QlikView/Need-help-in-expression/m-p/356645#M132346 2012-06-18T07:08:18Z Re: Need help in expression https://community.qlik.com/t5/QlikView/Need-help-in-expression/m-p/356646#M132347 <HTML><HEAD></HEAD><BODY><P>You're welcome. Miguel also answered already <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P></BODY></HTML> Mon, 18 Jun 2012 07:09:00 GMT https://community.qlik.com/t5/QlikView/Need-help-in-expression/m-p/356646#M132347 2012-06-18T07:09:00Z