topic Fit Columns To Data in QlikView https://community.qlik.com/t5/QlikView/Fit-Columns-To-Data/m-p/221891#M74648 <HTML><HEAD></HEAD><BODY><P>Hello.</P><P>I know about "Fit Columns To Data" function in the straight table context menu.</P><P>But is there a macro function for that?</P><P>Thank you.</P></BODY></HTML> Tue, 13 Jul 2010 11:44:42 GMT 2010-07-13T11:44:42Z Fit Columns To Data https://community.qlik.com/t5/QlikView/Fit-Columns-To-Data/m-p/221891#M74648 <HTML><HEAD></HEAD><BODY><P>Hello.</P><P>I know about "Fit Columns To Data" function in the straight table context menu.</P><P>But is there a macro function for that?</P><P>Thank you.</P></BODY></HTML> Tue, 13 Jul 2010 11:44:42 GMT https://community.qlik.com/t5/QlikView/Fit-Columns-To-Data/m-p/221891#M74648 2010-07-13T11:44:42Z Fit Columns To Data https://community.qlik.com/t5/QlikView/Fit-Columns-To-Data/m-p/221892#M74649 <HTML><HEAD></HEAD><BODY><P>You can use something like this:</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">set mybox = ActiveDocument.ActiveSheet.CreateTableBox<BR />mybox.AddField "Class"<BR />mybox.AddField "ClassComment"<BR />set tbp = mybox.GetProperties<BR />tbp.Layout.ColLayouts.Item(0).ColWidth = 200<BR />tbp.Layout.ColLayouts.Item(1).ColWidth = 400<BR />mybox.SetProperties tbp<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P>Instead of 200 and 400 you can calculate a maximum length for the columns.</P></BODY></HTML> Tue, 13 Jul 2010 14:21:35 GMT https://community.qlik.com/t5/QlikView/Fit-Columns-To-Data/m-p/221892#M74649 2010-07-13T14:21:35Z Fit Columns To Data https://community.qlik.com/t5/QlikView/Fit-Columns-To-Data/m-p/221893#M74650 <HTML><HEAD></HEAD><BODY><P>No</P><P>I want to have an autofit depending on length of data in fields just like the manual "Fit Columns To Data" function.</P><P>UPD: Ah, sorry. You mean to calculate the maximum length before formating table layout. Yes, thank you, I'll try this.</P><P>But I hoped there is simplier way <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P></BODY></HTML> Tue, 13 Jul 2010 14:33:24 GMT https://community.qlik.com/t5/QlikView/Fit-Columns-To-Data/m-p/221893#M74650 2010-07-13T14:33:24Z