topic Re: How to create a macro to clear variables using For statement in QlikView https://community.qlik.com/t5/QlikView/How-to-create-a-macro-to-clear-variables-using-For-statement/m-p/1519890#M437420 <P>For loop should start with 1, not zero?</P> Wed, 12 Dec 2018 14:25:23 GMT m_woolf 2018-12-12T14:25:23Z How to create a macro to clear variables using For statement https://community.qlik.com/t5/QlikView/How-to-create-a-macro-to-clear-variables-using-For-statement/m-p/1519887#M437419 <P>Hi everyone,</P><P>I don't know why this Macro is failing.</P><P>&nbsp;</P><P>Sub Clear<BR /><BR />&nbsp;&nbsp; &nbsp;For i = 0 to 19 Step 1<BR />&nbsp;&nbsp; &nbsp;<BR />&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;ActiveDocument.Variables("vGroup"&amp;i).SetContent "",true<BR />&nbsp;&nbsp; &nbsp;<BR />&nbsp;&nbsp; &nbsp;Next<BR /><BR />End Sub</P><P>&nbsp;</P><P>Anyone see something wrong?</P><P>What I need is to clear variables vGroup from 1 to 19</P> Sat, 16 Nov 2024 04:58:54 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-macro-to-clear-variables-using-For-statement/m-p/1519887#M437419 arngue 2024-11-16T04:58:54Z Re: How to create a macro to clear variables using For statement https://community.qlik.com/t5/QlikView/How-to-create-a-macro-to-clear-variables-using-For-statement/m-p/1519890#M437420 <P>For loop should start with 1, not zero?</P> Wed, 12 Dec 2018 14:25:23 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-macro-to-clear-variables-using-For-statement/m-p/1519890#M437420 m_woolf 2018-12-12T14:25:23Z Re: How to create a macro to clear variables using For statement https://community.qlik.com/t5/QlikView/How-to-create-a-macro-to-clear-variables-using-For-statement/m-p/1519906#M437422 <P>Hi,</P><P>Your code is running right for me.</P><P>What&nbsp;kind of mistake are you getting for?</P><P>Ag+</P> Wed, 12 Dec 2018 14:43:27 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-macro-to-clear-variables-using-For-statement/m-p/1519906#M437422 albert_guito 2018-12-12T14:43:27Z Re: How to create a macro to clear variables using For statement https://community.qlik.com/t5/QlikView/How-to-create-a-macro-to-clear-variables-using-For-statement/m-p/1519918#M437424 <P>Sorry, my fault, idiot me...</P><P>&nbsp;</P><P>Thanks for Awnsers!</P> Wed, 12 Dec 2018 14:58:35 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-macro-to-clear-variables-using-For-statement/m-p/1519918#M437424 arngue 2018-12-12T14:58:35Z