topic Update and assign variable in Macro in QlikView https://community.qlik.com/t5/QlikView/Update-and-assign-variable-in-Macro/m-p/670616#M1071512 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I woud like to increment a variable 'vIncr' in Macro definition and assign the resulting value to another variable 'vLatest'. Please help me in achieving this. Thanks in advance...</P></BODY></HTML> Thu, 28 Aug 2014 14:35:44 GMT 2014-08-28T14:35:44Z Update and assign variable in Macro https://community.qlik.com/t5/QlikView/Update-and-assign-variable-in-Macro/m-p/670616#M1071512 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I woud like to increment a variable 'vIncr' in Macro definition and assign the resulting value to another variable 'vLatest'. Please help me in achieving this. Thanks in advance...</P></BODY></HTML> Thu, 28 Aug 2014 14:35:44 GMT https://community.qlik.com/t5/QlikView/Update-and-assign-variable-in-Macro/m-p/670616#M1071512 2014-08-28T14:35:44Z Re: Update and assign variable in Macro https://community.qlik.com/t5/QlikView/Update-and-assign-variable-in-Macro/m-p/670617#M1071513 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P>var = ActiveDocument.Variables("var1").GetContent.String</P><P>ActiveDocument.Variables("var2").SetContent var, true</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 28 Aug 2014 14:56:54 GMT https://community.qlik.com/t5/QlikView/Update-and-assign-variable-in-Macro/m-p/670617#M1071513 marcus_sommer 2014-08-28T14:56:54Z Re: Update and assign variable in Macro https://community.qlik.com/t5/QlikView/Update-and-assign-variable-in-Macro/m-p/670618#M1071514 <HTML><HEAD></HEAD><BODY><P>Hi Marcus</P><P></P><P>I want to first increment the value of variable before assigning it to another variable. Main question is : how to increment the value of variable by 1.</P></BODY></HTML> Thu, 28 Aug 2014 15:04:51 GMT https://community.qlik.com/t5/QlikView/Update-and-assign-variable-in-Macro/m-p/670618#M1071514 2014-08-28T15:04:51Z Re: Update and assign variable in Macro https://community.qlik.com/t5/QlikView/Update-and-assign-variable-in-Macro/m-p/670619#M1071515 <HTML><HEAD></HEAD><BODY><P>var = ActiveDocument.Variables("var1").GetContent.String</P><P></P><P>var = var + 1</P><P></P><P>ActiveDocument.Variables("var2").SetContent var, true</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 28 Aug 2014 15:07:21 GMT https://community.qlik.com/t5/QlikView/Update-and-assign-variable-in-Macro/m-p/670619#M1071515 marcus_sommer 2014-08-28T15:07:21Z Re: Update and assign variable in Macro https://community.qlik.com/t5/QlikView/Update-and-assign-variable-in-Macro/m-p/670620#M1071516 <HTML><HEAD></HEAD><BODY><P>Great.. Thanks Marcus</P></BODY></HTML> Thu, 28 Aug 2014 15:12:45 GMT https://community.qlik.com/t5/QlikView/Update-and-assign-variable-in-Macro/m-p/670620#M1071516 2014-08-28T15:12:45Z