Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
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
nilesh_gangurde
Partner
Partner

Hi Sumit,

Can you elaborate the requirment.

What you want to do Actualy ??

Regards,

Nilesh Gangurde

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.

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

....

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

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?

tamilarasu

Hi Deborah,

Could you open a new thread for this issue. ?

Not applicable

Not applicable

This worked so I am good!  Thank you

tamilarasu

Glad the you found the solution.