topic Modify Expression in QlikView https://community.qlik.com/t5/QlikView/Modify-Expression/m-p/591463#M219348 <HTML><HEAD></HEAD><BODY><P>sum({&lt;R_YEAR=, <SPAN style="color: #ff0000;"><STRONG>R_MONTH={'&gt;$(=max(R_MONTH))'}</STRONG>,</SPAN> To_YEAR={$(=max(R_YEAR)+1)},To_MONTH={'&gt;=$(=max(R_MONTH))&lt;=$(=max(R_MONTH))'}, POL_TYPE={'F'}&gt;}[PREMIUM] )</P><P></P><P>Pls refer my attachment and I want the above highlighted part of the expression to change as R_Month should be months coming after the R_Month and all other conditions should remain as it is</P><P>Eg If User select R_Month=Jan Expression should select Feb-dec</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; R_Month=Dec Expression should select Jan-Nov etc</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; R_Month=Jun Expression should select Jul-May etc</P><P>Pls help me </P></BODY></HTML> Sun, 16 Feb 2014 16:38:06 GMT upaliwije 2014-02-16T16:38:06Z Modify Expression https://community.qlik.com/t5/QlikView/Modify-Expression/m-p/591463#M219348 <HTML><HEAD></HEAD><BODY><P>sum({&lt;R_YEAR=, <SPAN style="color: #ff0000;"><STRONG>R_MONTH={'&gt;$(=max(R_MONTH))'}</STRONG>,</SPAN> To_YEAR={$(=max(R_YEAR)+1)},To_MONTH={'&gt;=$(=max(R_MONTH))&lt;=$(=max(R_MONTH))'}, POL_TYPE={'F'}&gt;}[PREMIUM] )</P><P></P><P>Pls refer my attachment and I want the above highlighted part of the expression to change as R_Month should be months coming after the R_Month and all other conditions should remain as it is</P><P>Eg If User select R_Month=Jan Expression should select Feb-dec</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; R_Month=Dec Expression should select Jan-Nov etc</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; R_Month=Jun Expression should select Jul-May etc</P><P>Pls help me </P></BODY></HTML> Sun, 16 Feb 2014 16:38:06 GMT https://community.qlik.com/t5/QlikView/Modify-Expression/m-p/591463#M219348 upaliwije 2014-02-16T16:38:06Z