topic Re: Assistance with expression in QlikView https://community.qlik.com/t5/QlikView/Assistance-with-expression/m-p/738865#M1076726 <HTML><HEAD></HEAD><BODY><P>Use a set expression, something like:</P><P>{&lt;Month='$(=Date(AddMonths(Date#(Max([order_date]),'YYYYM'),-$(=<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">mnthin</SPAN>)),'MMM-YY'))'&gt;}</P><P></P><P>Where:</P><P>-Month is an field containing the months from your date</P><P>-The -$(=mnthin) will subtract the required months</P><P>-You need to change the date formats to your own</P></BODY></HTML> Thu, 24 Jul 2014 13:31:08 GMT stigchel 2014-07-24T13:31:08Z Assistance with expression https://community.qlik.com/t5/QlikView/Assistance-with-expression/m-p/738859#M1076720 <HTML><HEAD></HEAD><BODY><P>I need an expression to work out the value of sales within a period.</P><P></P><P>Unit price x qty</P><P></P><P>however, I want to be able to use another field (mnthin) to determine how far I look back.</P><P>if this column is 3 - I would like to go back 3 months from today and find value. if 5 then start five months back. etc.</P><P></P><P>Could anyone help please?</P></BODY></HTML> Thu, 24 Jul 2014 12:30:12 GMT https://community.qlik.com/t5/QlikView/Assistance-with-expression/m-p/738859#M1076720 2014-07-24T12:30:12Z Re: Assistance with expression https://community.qlik.com/t5/QlikView/Assistance-with-expression/m-p/738860#M1076721 <HTML><HEAD></HEAD><BODY><P>Provide sample data please along with your requirements...</P></BODY></HTML> Thu, 24 Jul 2014 12:40:35 GMT https://community.qlik.com/t5/QlikView/Assistance-with-expression/m-p/738860#M1076721 MK_QSL 2014-07-24T12:40:35Z Re: Assistance with expression https://community.qlik.com/t5/QlikView/Assistance-with-expression/m-p/738861#M1076722 <HTML><HEAD></HEAD><BODY><P>Ill put something together and attach - thanks!</P></BODY></HTML> Thu, 24 Jul 2014 12:48:32 GMT https://community.qlik.com/t5/QlikView/Assistance-with-expression/m-p/738861#M1076722 2014-07-24T12:48:32Z Re: Re: Assistance with expression https://community.qlik.com/t5/QlikView/Assistance-with-expression/m-p/738862#M1076723 <HTML><HEAD></HEAD><BODY><P>Please see attached requirement</P></BODY></HTML> Thu, 24 Jul 2014 13:01:51 GMT https://community.qlik.com/t5/QlikView/Assistance-with-expression/m-p/738862#M1076723 2014-07-24T13:01:51Z Re: Assistance with expression https://community.qlik.com/t5/QlikView/Assistance-with-expression/m-p/738863#M1076724 <HTML><HEAD></HEAD><BODY><P>Still not clear... Kindly provide output you want...</P></BODY></HTML> Thu, 24 Jul 2014 13:09:56 GMT https://community.qlik.com/t5/QlikView/Assistance-with-expression/m-p/738863#M1076724 MK_QSL 2014-07-24T13:09:56Z Re: Assistance with expression https://community.qlik.com/t5/QlikView/Assistance-with-expression/m-p/738864#M1076725 <HTML><HEAD></HEAD><BODY><P>Manish I have put the requirement within the document</P></BODY></HTML> Thu, 24 Jul 2014 13:18:45 GMT https://community.qlik.com/t5/QlikView/Assistance-with-expression/m-p/738864#M1076725 2014-07-24T13:18:45Z Re: Assistance with expression https://community.qlik.com/t5/QlikView/Assistance-with-expression/m-p/738865#M1076726 <HTML><HEAD></HEAD><BODY><P>Use a set expression, something like:</P><P>{&lt;Month='$(=Date(AddMonths(Date#(Max([order_date]),'YYYYM'),-$(=<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">mnthin</SPAN>)),'MMM-YY'))'&gt;}</P><P></P><P>Where:</P><P>-Month is an field containing the months from your date</P><P>-The -$(=mnthin) will subtract the required months</P><P>-You need to change the date formats to your own</P></BODY></HTML> Thu, 24 Jul 2014 13:31:08 GMT https://community.qlik.com/t5/QlikView/Assistance-with-expression/m-p/738865#M1076726 stigchel 2014-07-24T13:31:08Z Re: Assistance with expression https://community.qlik.com/t5/QlikView/Assistance-with-expression/m-p/738866#M1076727 <HTML><HEAD></HEAD><BODY><P>Thank you for your help <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 24 Jul 2014 14:01:31 GMT https://community.qlik.com/t5/QlikView/Assistance-with-expression/m-p/738866#M1076727 2014-07-24T14:01:31Z Re: Assistance with expression https://community.qlik.com/t5/QlikView/Assistance-with-expression/m-p/738867#M1076728 <HTML><HEAD></HEAD><BODY><P>You're welcome <IMG src="https://community.qlik.com/legacyfs/online/emoticons/cool.png" /></P></BODY></HTML> Thu, 24 Jul 2014 14:38:31 GMT https://community.qlik.com/t5/QlikView/Assistance-with-expression/m-p/738867#M1076728 stigchel 2014-07-24T14:38:31Z