topic Expression - Update values into variables in QlikView https://community.qlik.com/t5/QlikView/Expression-Update-values-into-variables/m-p/732477#M262375 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have 4 variables.</P><P>vMaxMth1</P><P>vMaxMth2</P><P>vMaxMth3</P><P>vMaxMth4</P><P></P><P>If I have value in vMaxMth1 = 31/08/2014'. I need other 3 variables file up as below.</P><P></P><P>vMaxMth2 - 31/07/2014</P><P>vMaxMth3 - 30/06/2014</P><P>vMaxMth4 - 31/05/2014.</P><P></P><P>How can I do that?</P></BODY></HTML> Thu, 18 Sep 2014 13:18:04 GMT 2014-09-18T13:18:04Z Expression - Update values into variables https://community.qlik.com/t5/QlikView/Expression-Update-values-into-variables/m-p/732477#M262375 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have 4 variables.</P><P>vMaxMth1</P><P>vMaxMth2</P><P>vMaxMth3</P><P>vMaxMth4</P><P></P><P>If I have value in vMaxMth1 = 31/08/2014'. I need other 3 variables file up as below.</P><P></P><P>vMaxMth2 - 31/07/2014</P><P>vMaxMth3 - 30/06/2014</P><P>vMaxMth4 - 31/05/2014.</P><P></P><P>How can I do that?</P></BODY></HTML> Thu, 18 Sep 2014 13:18:04 GMT https://community.qlik.com/t5/QlikView/Expression-Update-values-into-variables/m-p/732477#M262375 2014-09-18T13:18:04Z Re: Expression - Update values into variables https://community.qlik.com/t5/QlikView/Expression-Update-values-into-variables/m-p/732478#M262376 <HTML><HEAD></HEAD><BODY><P>vMaxMth2</P><P>=AddMonths('$(vMaxMth1)',-1)</P><P></P><P>vMaxMth3</P><P>=AddMonths('$(vMaxMth1)',-2)</P><P></P><P>vMaxMth4</P><P>=AddMonths('$(vMaxMth1)',-3)</P></BODY></HTML> Thu, 18 Sep 2014 13:23:51 GMT https://community.qlik.com/t5/QlikView/Expression-Update-values-into-variables/m-p/732478#M262376 MK_QSL 2014-09-18T13:23:51Z