topic Expression for previous month in QlikView https://community.qlik.com/t5/QlikView/Expression-for-previous-month/m-p/331934#M122293 <HTML><HEAD></HEAD><BODY><P> the above expression is not working.......... I need to just show the data related the previous month............</P></BODY></HTML> Thu, 01 Mar 2012 13:34:58 GMT 2012-03-01T13:34:58Z Expression for previous month https://community.qlik.com/t5/QlikView/Expression-for-previous-month/m-p/331928#M122287 <HTML><HEAD></HEAD><BODY><P>&nbsp; I need the expression for previous month using set analysis............ I have the expression for it which is MonthName(AddMonths(Today(),-1)) but i need it in set analysis..........thnx in advance.........</P></BODY></HTML> Thu, 01 Mar 2012 12:26:05 GMT https://community.qlik.com/t5/QlikView/Expression-for-previous-month/m-p/331928#M122287 2012-03-01T12:26:05Z Re: Expression for previous month https://community.qlik.com/t5/QlikView/Expression-for-previous-month/m-p/331929#M122288 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Use as it is</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Sum({&lt;MonthYearFieldName={'$(= MonthName(AddMonths(Today(),-1)))'}&gt;} Sales)</P><P>&nbsp;&nbsp;&nbsp;&nbsp; MonthYearFieldName is the Field you created using MonthName function in the load script.</P><P>Celambarasan</P></BODY></HTML> Thu, 01 Mar 2012 12:29:39 GMT https://community.qlik.com/t5/QlikView/Expression-for-previous-month/m-p/331929#M122288 CELAMBARASAN 2012-03-01T12:29:39Z Re: Expression for previous month https://community.qlik.com/t5/QlikView/Expression-for-previous-month/m-p/331930#M122289 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Hope the following attached file will be helpful for your problem</P><P></P><P></P><P>Regards</P><P></P><P>Ashok</P></BODY></HTML> Thu, 01 Mar 2012 13:02:59 GMT https://community.qlik.com/t5/QlikView/Expression-for-previous-month/m-p/331930#M122289 Anonymous 2012-03-01T13:02:59Z Expression for previous month https://community.qlik.com/t5/QlikView/Expression-for-previous-month/m-p/331931#M122290 <HTML><HEAD></HEAD><BODY><P> Thanx for reply Celam........... I m using this expression for fetching the data for previous month...........but it is not giving the result............so i thought to use set analysis............. The expression is&nbsp;&nbsp; if(MonthName(AddMonths(Today(),-1))=TIME_FRAME.TIME_FROM,RULES_SPECIAL.FACTOR_VALUE)............Can u suggest me something on this..............</P></BODY></HTML> Thu, 01 Mar 2012 13:20:38 GMT https://community.qlik.com/t5/QlikView/Expression-for-previous-month/m-p/331931#M122290 2012-03-01T13:20:38Z Expression for previous month https://community.qlik.com/t5/QlikView/Expression-for-previous-month/m-p/331932#M122291 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; The expression should be</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Sum({&lt;TIME_FRAME.TIME_FROM={'$(=MonthName(AddMonths(Today(),-1)))'}&gt;} RULES_SPECIAL.FACTOR_VALUE)</P><P></P><P>Before that What type data in the TIME_FRAME.TIME_FROM field?</P><P></P><P>Celambarasan</P></BODY></HTML> Thu, 01 Mar 2012 13:25:05 GMT https://community.qlik.com/t5/QlikView/Expression-for-previous-month/m-p/331932#M122291 CELAMBARASAN 2012-03-01T13:25:05Z Expression for previous month https://community.qlik.com/t5/QlikView/Expression-for-previous-month/m-p/331933#M122292 <HTML><HEAD></HEAD><BODY><P> thanx for reply........ TIME_FRAME.TIME_FROM&nbsp; is date in format mm/dd/yyyy............</P></BODY></HTML> Thu, 01 Mar 2012 13:30:23 GMT https://community.qlik.com/t5/QlikView/Expression-for-previous-month/m-p/331933#M122292 2012-03-01T13:30:23Z Expression for previous month https://community.qlik.com/t5/QlikView/Expression-for-previous-month/m-p/331934#M122293 <HTML><HEAD></HEAD><BODY><P> the above expression is not working.......... I need to just show the data related the previous month............</P></BODY></HTML> Thu, 01 Mar 2012 13:34:58 GMT https://community.qlik.com/t5/QlikView/Expression-for-previous-month/m-p/331934#M122293 2012-03-01T13:34:58Z Expression for previous month https://community.qlik.com/t5/QlikView/Expression-for-previous-month/m-p/331935#M122294 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Try with this</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Sum({&lt;TIME_FRAME.TIME_FROM={"&gt;=$(=MonthStart(Today(),-1))&lt;=$(=MonthEnd(Today(),-1))'}&gt;} RULES_SPECIAL.FACTOR_VALUE)</P><P></P><P>Celambarasan</P></BODY></HTML> Thu, 01 Mar 2012 14:05:14 GMT https://community.qlik.com/t5/QlikView/Expression-for-previous-month/m-p/331935#M122294 CELAMBARASAN 2012-03-01T14:05:14Z Expression for previous month https://community.qlik.com/t5/QlikView/Expression-for-previous-month/m-p/331936#M122295 <HTML><HEAD></HEAD><BODY><P> Hi celam..........</P><P></P><P>the RULES_SPECIAL.FACTOR_VALUE&nbsp; contains <STRONG>Factor: 0.2</STRONG> types entities.........i can't use SUM there.........so suggest something beside from sum...............thanx for reply</P></BODY></HTML> Thu, 01 Mar 2012 14:34:48 GMT https://community.qlik.com/t5/QlikView/Expression-for-previous-month/m-p/331936#M122295 2012-03-01T14:34:48Z Expression for previous month https://community.qlik.com/t5/QlikView/Expression-for-previous-month/m-p/331937#M122296 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Ok then you have to try with</P><P>&nbsp;&nbsp;&nbsp;&nbsp; MaxString,MinString,Only,Concat functions</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Use this</P><P>&nbsp;&nbsp;&nbsp;&nbsp; =MaxString({&lt;TIME_FRAME.TIME_FROM={"&gt;=$(=MonthStart(Today(),-1))&lt;=$(=MonthEnd(Today(),-1))'}&gt;} RULES_SPECIAL.FACTOR_VALUE)</P><P></P><P>Celambarasan</P></BODY></HTML> Thu, 01 Mar 2012 14:41:30 GMT https://community.qlik.com/t5/QlikView/Expression-for-previous-month/m-p/331937#M122296 CELAMBARASAN 2012-03-01T14:41:30Z