topic Setting a variable with an array of values taken by a pivot table though a macro in QlikView

topic Setting a variable with an array of values taken by a pivot table though a macro in QlikView https://community.qlik.com/t5/QlikView/Setting-a-variable-with-an-array-of-values-taken-by-a-pivot/m-p/168481#M39619 <HTML><HEAD></HEAD><BODY><P>Upload your QV app</P></BODY></HTML> Thu, 13 Jan 2011 17:13:05 GMT 2011-01-13T17:13:05Z Setting a variable with an array of values taken by a pivot table though a macro https://community.qlik.com/t5/QlikView/Setting-a-variable-with-an-array-of-values-taken-by-a-pivot/m-p/168480#M39618 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I'm trying to set a variable into a qlikview document with a list of values taken from a column of a pivot table.</P><P></P><P>Here's the code:</P><P></P><P></P><H4>sub GetContattiInviti</H4><H4><BR />set table = ActiveDocument.GetSheetObject("CH146")</H4><H4><BR />'set field = ActiveDocument.Fields("Con_cod_contatto")</H4><H4><BR />'set arrayValori = field.GetNoValues</H4><H4><BR />dim arrayValori: arrayValori=(table.GetRowCount)</H4><H4><BR />cont = 0</H4><H4><BR />for RowIter = 1 to table.GetRowCount-1</H4><H4></H4><H4>set cell = table.GetCell(RowIter,2)</H4><H4>if cell.Text <> "0" then arrayValori(cont).Text = cell.Text</H4><H4>cont = cont + 1</H4><H4>next</H4><H4><BR /></H4><H4>set contattiPriorita = ActiveDocument.Variables("Contatti_Priorita")</H4><H4>contattiPriorita.SetContent arrayValori,true</H4><H4><BR />end sub</H4><P></P><P>The instruction</P><H4>arrayValori(cont).Text = cell.Text</H4><P></P><P>gives me Type Mismatch error.</P><P>I tried a lot of things without success.</P><P></P><P>Any suggestions?</P><P></P><P>Thanks in advance!</P><P></P></BODY></HTML> Thu, 13 Jan 2011 17:09:58 GMT https://community.qlik.com/t5/QlikView/Setting-a-variable-with-an-array-of-values-taken-by-a-pivot/m-p/168480#M39618 2011-01-13T17:09:58Z Setting a variable with an array of values taken by a pivot table though a macro https://community.qlik.com/t5/QlikView/Setting-a-variable-with-an-array-of-values-taken-by-a-pivot/m-p/168481#M39619 <HTML><HEAD></HEAD><BODY><P>Upload your QV app</P></BODY></HTML> Thu, 13 Jan 2011 17:13:05 GMT https://community.qlik.com/t5/QlikView/Setting-a-variable-with-an-array-of-values-taken-by-a-pivot/m-p/168481#M39619 2011-01-13T17:13:05Z Setting a variable with an array of values taken by a pivot table though a macro https://community.qlik.com/t5/QlikView/Setting-a-variable-with-an-array-of-values-taken-by-a-pivot/m-p/168482#M39620 <HTML><HEAD></HEAD><BODY><P>Hi alecatta - did you find a solution for this? thanks</P></BODY></HTML> Thu, 17 Feb 2011 11:42:01 GMT https://community.qlik.com/t5/QlikView/Setting-a-variable-with-an-array-of-values-taken-by-a-pivot/m-p/168482#M39620 nathanfurby 2011-02-17T11:42:01Z