Sheet design question

[#1]

Hello.
I have a question.
There are a few straight tables on a sheet and an ListBox.
Data in the tables change depending on the selected ListBox parameter .

The size of tables changed also, scroll bar appears.

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.
Is it possible here to do something? Thank you.

[#2]

Hi,

You can try to do this

Place the tables on the sheet as you wish so they don't overlap

and set Layout -> Adjust Object Maximum Size to Current Size

I think it's the best way.

Regards,

Andris

[#3]

No it's not suitable

The data in the tables imports from SQL Server and maybe tomorrow the number of rows in tables will be different.

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.

[#4]

Well, then the only thing You can do is to write a macro

On selection in List Box it changes the position for tables depending of previous table size

Regards,

Andris

[#5]

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?

[#6]

In folder where You install QV is Documentation folder with

APIguide.qvw and QlikView Automation Reference.pdf

Andris

[#7 · Accepted solution]

Hi

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.

Hope this helps

[#8]

Thanks for this.

It doesn't look good but work.

I try it.

[#9]

Glad I could help