Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Macro for increasing row height

I want a macro for increasing row height of a table

.

I could not find that in the API Guide

9 Replies
Highlighted
Partner
Partner

Hi Sumit,

Can you elaborate the requirment.

What you want to do Actualy ??

Regards,

Nilesh Gangurde

Highlighted
Not applicable

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.

Highlighted
Not applicable

Hi

Try this code,It will increase the cell height.

Sub Height

set TB = ActiveDocument.GetSheetObject("TB01")

set box=TB.GetProperties

box.Layout.MultiLine = 2

TB.SetProperties box

End Sub

Hope it helps you...

Regards

....

Highlighted
Not applicable

can you use a variable in place of the 2 in the multiline properties?  I tried a few ways but not working.  What is syntax if possible, for using variable in macro

Highlighted
Not applicable

Sub Height



set TB = ActiveDocument.GetSheetObject("TB03")

set box=TB.GetProperties
set vRows = ActiveDocument.GetVariable("vRowHeight")


box.Layout.MultiLine = vRows

TB.SetProperties box

End Sub

This is not working.  how do I pass the variable to the box.layout.multline setting?

Highlighted

Hi Deborah,

Could you open a new thread for this issue. ?

Highlighted
Not applicable

Highlighted
Not applicable

This worked so I am good!  Thank you

Highlighted

Glad the you found the solution.