topic Sheet design question in QlikView https://community.qlik.com/t5/QlikView/Sheet-design-question/m-p/215360#M68824 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>You can always try the option of sizing to data. go to the properties of the table you want to remain the same size and look for size to data and uncheck it. now you can adjust the size however you want and no matter what you select, it will stay the same size.</P><P></P><P>Hope this helps</P><P></P></BODY></HTML> Tue, 06 Jul 2010 10:17:46 GMT 2010-07-06T10:17:46Z Sheet design question https://community.qlik.com/t5/QlikView/Sheet-design-question/m-p/215354#M68818 <HTML><HEAD></HEAD><BODY><P>Hello.<BR />I have a question.<BR />There are a few straight tables on a sheet and an ListBox.<BR />Data in the tables change depending on the selected ListBox parameter .</P><P>The size of tables changed also, scroll bar appears.</P><P>I wish that all tables are automatically expanded in height, as well as the following table was placed directly under the previous, so that they never overlapped.<BR />Is it possible here to do something? Thank you.</P></BODY></HTML> Tue, 06 Jul 2010 08:07:23 GMT https://community.qlik.com/t5/QlikView/Sheet-design-question/m-p/215354#M68818 2010-07-06T08:07:23Z Sheet design question https://community.qlik.com/t5/QlikView/Sheet-design-question/m-p/215355#M68819 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can try to do this</P><P>Place the tables on the sheet as you wish so they don't overlap</P><P>and set Layout -&gt; Adjust Object Maximum Size to Current Size</P><P>I think it's the best way.</P><P></P><P>Regards,</P><P>Andris</P></BODY></HTML> Tue, 06 Jul 2010 08:34:55 GMT https://community.qlik.com/t5/QlikView/Sheet-design-question/m-p/215355#M68819 2010-07-06T08:34:55Z Sheet design question https://community.qlik.com/t5/QlikView/Sheet-design-question/m-p/215356#M68820 <HTML><HEAD></HEAD><BODY><P>No it's not suitable</P><P>The data in the tables imports from SQL Server and maybe tomorrow the number of rows in tables will be different.</P><P>And if the number of rows increases then the vertical scroll bar will appear again cause the data will not fit the previously fixed size.</P></BODY></HTML> Tue, 06 Jul 2010 09:01:26 GMT https://community.qlik.com/t5/QlikView/Sheet-design-question/m-p/215356#M68820 2010-07-06T09:01:26Z Sheet design question https://community.qlik.com/t5/QlikView/Sheet-design-question/m-p/215357#M68821 <HTML><HEAD></HEAD><BODY><P>Well, then the only thing You can do is to write a macro</P><P>On selection in List Box it changes the position for tables depending of previous table size</P><P></P><P>Regards,</P><P>Andris</P></BODY></HTML> Tue, 06 Jul 2010 09:11:21 GMT https://community.qlik.com/t5/QlikView/Sheet-design-question/m-p/215357#M68821 2010-07-06T09:11:21Z Sheet design question https://community.qlik.com/t5/QlikView/Sheet-design-question/m-p/215358#M68822 <HTML><HEAD></HEAD><BODY><P>Could you advise me where I can read about the functions that change the size and layout of tables and could be used in macro?</P></BODY></HTML> Tue, 06 Jul 2010 09:20:28 GMT https://community.qlik.com/t5/QlikView/Sheet-design-question/m-p/215358#M68822 2010-07-06T09:20:28Z Sheet design question https://community.qlik.com/t5/QlikView/Sheet-design-question/m-p/215359#M68823 <HTML><HEAD></HEAD><BODY><P>In folder where You install QV is Documentation folder with</P><P>APIguide.qvw and QlikView Automation Reference.pdf</P><P></P><P>Andris</P></BODY></HTML> Tue, 06 Jul 2010 10:00:21 GMT https://community.qlik.com/t5/QlikView/Sheet-design-question/m-p/215359#M68823 2010-07-06T10:00:21Z Sheet design question https://community.qlik.com/t5/QlikView/Sheet-design-question/m-p/215360#M68824 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>You can always try the option of sizing to data. go to the properties of the table you want to remain the same size and look for size to data and uncheck it. now you can adjust the size however you want and no matter what you select, it will stay the same size.</P><P></P><P>Hope this helps</P><P></P></BODY></HTML> Tue, 06 Jul 2010 10:17:46 GMT https://community.qlik.com/t5/QlikView/Sheet-design-question/m-p/215360#M68824 2010-07-06T10:17:46Z Sheet design question https://community.qlik.com/t5/QlikView/Sheet-design-question/m-p/215361#M68825 <HTML><HEAD></HEAD><BODY><P>Thanks for this.</P><P>It doesn't look good but work.</P><P>I try it.</P></BODY></HTML> Tue, 06 Jul 2010 11:09:20 GMT https://community.qlik.com/t5/QlikView/Sheet-design-question/m-p/215361#M68825 2010-07-06T11:09:20Z Sheet design question https://community.qlik.com/t5/QlikView/Sheet-design-question/m-p/215362#M68826 <HTML><HEAD></HEAD><BODY><P>Glad I could help</P></BODY></HTML> Tue, 06 Jul 2010 11:17:16 GMT https://community.qlik.com/t5/QlikView/Sheet-design-question/m-p/215362#M68826 2010-07-06T11:17:16Z