topic QlikView Macro for TableBox in QlikView https://community.qlik.com/t5/QlikView/QlikView-Macro-for-TableBox/m-p/672246#M244163 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I am trying to create a table box automatically using a macro. </P><P></P><P>I have a list of fields already and I want to add these fields to the table box through a macro. As suggested in the API guide, it is not possible to manually add all the fields using addfield "Class" etc. Please suggest me a way for this.</P><P></P><P></P><P></P><P>Cheers,</P><P>Naresh</P></BODY></HTML> Tue, 07 Oct 2014 12:02:39 GMT NareshGuntur 2014-10-07T12:02:39Z QlikView Macro for TableBox https://community.qlik.com/t5/QlikView/QlikView-Macro-for-TableBox/m-p/672246#M244163 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I am trying to create a table box automatically using a macro. </P><P></P><P>I have a list of fields already and I want to add these fields to the table box through a macro. As suggested in the API guide, it is not possible to manually add all the fields using addfield "Class" etc. Please suggest me a way for this.</P><P></P><P></P><P></P><P>Cheers,</P><P>Naresh</P></BODY></HTML> Tue, 07 Oct 2014 12:02:39 GMT https://community.qlik.com/t5/QlikView/QlikView-Macro-for-TableBox/m-p/672246#M244163 NareshGuntur 2014-10-07T12:02:39Z Re: QlikView Macro for TableBox https://community.qlik.com/t5/QlikView/QlikView-Macro-for-TableBox/m-p/672247#M244164 <HTML><HEAD></HEAD><BODY><P>Got this and it works fine</P><P></P><P>set mybox = ActiveDocument.GetSheetObject("M001")</P><P>MB = mybox.GetProperties</P><P>MB.Layout.Frame.Name.v=ActiveDocument.Variables("Variable1").GetContent.String</P><P>mybox.SetProperties MB</P><P></P><P> set MB = ActiveDocument.GetSheetObject("MB001")</P><P> For i = 0 to MB.GetRowcount - 1</P><P>&nbsp; MB.RemoveField 0</P><P> next</P><P> For i = 0 to GeoLabel.count - 1</P><P>&nbsp; MB.AddField GeoSelection.Item(i).text</P><P>&nbsp; mbp = MB.GetProperties</P><P>&nbsp; mbp.MemberAttributes.Item(i).Label.v = FieldLabel.item(i).text</P><P></P><P></P><P>&nbsp; MB.SetProperties mbp</P><P> Next</P></BODY></HTML> Mon, 18 May 2015 11:00:51 GMT https://community.qlik.com/t5/QlikView/QlikView-Macro-for-TableBox/m-p/672247#M244164 NareshGuntur 2015-05-18T11:00:51Z