topic Updating the variable in a loop...? in QlikView https://community.qlik.com/t5/QlikView/Updating-the-variable-in-a-loop/m-p/447649#M167061 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I want to update the value of a variable in a for...next loop in a macro. The macro goes through the lines of a specific chart in my document for a single column of the chart. Briefly, the followinh code gives an error because - as far as I understand- it takes the cell value as "text" from the chart and so it can not take the sums. Can anybody help me to find out how can I take the "value" of a cell of the chart?</P><P></P><P><SPAN style="font-size: 8pt;">Regards,&nbsp; </SPAN></P><P></P><P>for i = 0 to&nbsp; 'MV_Rowcount-1<BR />MV_Puan = MV_table.getcell(i,6).text<BR />MV_Puan = MV_Puan + MV_Puan<BR />next</P></BODY></HTML> Thu, 27 Sep 2012 09:52:31 GMT murozel76 2012-09-27T09:52:31Z Updating the variable in a loop...? https://community.qlik.com/t5/QlikView/Updating-the-variable-in-a-loop/m-p/447649#M167061 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I want to update the value of a variable in a for...next loop in a macro. The macro goes through the lines of a specific chart in my document for a single column of the chart. Briefly, the followinh code gives an error because - as far as I understand- it takes the cell value as "text" from the chart and so it can not take the sums. Can anybody help me to find out how can I take the "value" of a cell of the chart?</P><P></P><P><SPAN style="font-size: 8pt;">Regards,&nbsp; </SPAN></P><P></P><P>for i = 0 to&nbsp; 'MV_Rowcount-1<BR />MV_Puan = MV_table.getcell(i,6).text<BR />MV_Puan = MV_Puan + MV_Puan<BR />next</P></BODY></HTML> Thu, 27 Sep 2012 09:52:31 GMT https://community.qlik.com/t5/QlikView/Updating-the-variable-in-a-loop/m-p/447649#M167061 murozel76 2012-09-27T09:52:31Z