topic Re: Macro for increasing row height in QlikView https://community.qlik.com/t5/QlikView/Macro-for-increasing-row-height/m-p/343205#M126744 <HTML><HEAD></HEAD><BODY><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/122060_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Tue, 19 Apr 2016 15:14:05 GMT 2016-04-19T15:14:05Z Macro for increasing row height https://community.qlik.com/t5/QlikView/Macro-for-increasing-row-height/m-p/343198#M126737 <HTML><HEAD></HEAD><BODY><P>I want a macro for increasing row height of a table</P><P>.</P><P>I could not find that in the API Guide</P></BODY></HTML> Wed, 09 May 2012 07:35:40 GMT https://community.qlik.com/t5/QlikView/Macro-for-increasing-row-height/m-p/343198#M126737 2012-05-09T07:35:40Z Macro for increasing row height https://community.qlik.com/t5/QlikView/Macro-for-increasing-row-height/m-p/343199#M126738 <HTML><HEAD></HEAD><BODY><P>Hi Sumit,</P><P></P><P>Can you elaborate the requirment.</P><P>What you want to do Actualy ??</P><P></P><P>Regards,</P><P>Nilesh Gangurde</P></BODY></HTML> Wed, 09 May 2012 08:32:52 GMT https://community.qlik.com/t5/QlikView/Macro-for-increasing-row-height/m-p/343199#M126738 nilesh_gangurde 2012-05-09T08:32:52Z Macro for increasing row height https://community.qlik.com/t5/QlikView/Macro-for-increasing-row-height/m-p/343200#M126739 <HTML><HEAD></HEAD><BODY><P>i have a table with 10 rows. i have incorporated another table below that with one row. For some selection the second table disappears and that creates a void space below the first table. to remove that void space i want to adjust the height of the rows in first table such that it occupies the void space left.</P></BODY></HTML> Wed, 09 May 2012 08:47:21 GMT https://community.qlik.com/t5/QlikView/Macro-for-increasing-row-height/m-p/343200#M126739 2012-05-09T08:47:21Z Re: Macro for increasing row height https://community.qlik.com/t5/QlikView/Macro-for-increasing-row-height/m-p/343201#M126740 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>Try this code,It will increase the cell height.</P><P></P><P>Sub Height </P><P></P><P>set TB = ActiveDocument.GetSheetObject("TB01")</P><P>set box=TB.GetProperties</P><P>box.Layout.MultiLine = 2</P><P>TB.SetProperties box </P><P></P><P>End Sub</P><P></P><P>Hope it helps you...</P><P></P><P>Regards</P><P>....</P></BODY></HTML> Wed, 09 May 2012 08:57:36 GMT https://community.qlik.com/t5/QlikView/Macro-for-increasing-row-height/m-p/343201#M126740 2012-05-09T08:57:36Z Re: Macro for increasing row height https://community.qlik.com/t5/QlikView/Macro-for-increasing-row-height/m-p/343202#M126741 <HTML><HEAD></HEAD><BODY><P>can you use a variable in place of the 2 in the multiline properties?&nbsp; I tried a few ways but not working.&nbsp; What is syntax if possible, for using variable in macro</P></BODY></HTML> Tue, 19 Apr 2016 14:44:47 GMT https://community.qlik.com/t5/QlikView/Macro-for-increasing-row-height/m-p/343202#M126741 2016-04-19T14:44:47Z Re: Macro for increasing row height https://community.qlik.com/t5/QlikView/Macro-for-increasing-row-height/m-p/343203#M126742 <HTML><HEAD></HEAD><BODY><P></P><P>Sub Height <BR /> <BR /> <BR /> <BR /> set TB = ActiveDocument.GetSheetObject("TB03")<BR /> <BR /> set box=TB.GetProperties<BR /><STRONG> set vRows = ActiveDocument.GetVariable("vRowHeight")</STRONG><BR /> <BR /> <BR /> box.Layout.MultiLine = <STRONG>vRows</STRONG><BR /> <BR /> TB.SetProperties box <BR /> <BR /> End Sub </P><P></P><P>This is not working.&nbsp; how do I pass the variable to the box.layout.multline setting?</P></BODY></HTML> Tue, 19 Apr 2016 14:55:04 GMT https://community.qlik.com/t5/QlikView/Macro-for-increasing-row-height/m-p/343203#M126742 2016-04-19T14:55:04Z Re: Macro for increasing row height https://community.qlik.com/t5/QlikView/Macro-for-increasing-row-height/m-p/343204#M126743 <HTML><HEAD></HEAD><BODY><P>Hi Deborah, </P><P></P><P>Could you open a new thread for this issue. ?</P></BODY></HTML> Tue, 19 Apr 2016 15:09:51 GMT https://community.qlik.com/t5/QlikView/Macro-for-increasing-row-height/m-p/343204#M126743 tamilarasu 2016-04-19T15:09:51Z Re: Macro for increasing row height https://community.qlik.com/t5/QlikView/Macro-for-increasing-row-height/m-p/343205#M126744 <HTML><HEAD></HEAD><BODY><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/122060_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Tue, 19 Apr 2016 15:14:05 GMT https://community.qlik.com/t5/QlikView/Macro-for-increasing-row-height/m-p/343205#M126744 2016-04-19T15:14:05Z Re: Macro for increasing row height https://community.qlik.com/t5/QlikView/Macro-for-increasing-row-height/m-p/343206#M126745 <HTML><HEAD></HEAD><BODY><P>This worked so I am good!&nbsp; Thank you</P></BODY></HTML> Tue, 19 Apr 2016 15:14:29 GMT https://community.qlik.com/t5/QlikView/Macro-for-increasing-row-height/m-p/343206#M126745 2016-04-19T15:14:29Z Re: Macro for increasing row height https://community.qlik.com/t5/QlikView/Macro-for-increasing-row-height/m-p/343207#M126746 <HTML><HEAD></HEAD><BODY><P>Glad the you found the solution.<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 19 Apr 2016 15:15:26 GMT https://community.qlik.com/t5/QlikView/Macro-for-increasing-row-height/m-p/343207#M126746 tamilarasu 2016-04-19T15:15:26Z