Arrange tables in a sheet

[christian77]

Hi:

I need to place 3 tables in a single sheet. Tables take the whole screen width. They go one under the other.

3^rd table appears only when I select a single value on the 1^st dimension of the 1^st table.

The thing is: when I filter the 1^st table, a big gap appears between the bottom of Table 1 and the top of Table 2 since they’re fewer records.

How could I arrange that to minimize those gaps?

Why containers don’t adjust to data, like single table objects? Well, they should since they are meant to save room.

I’ve tried with a macro but it does not recognize size changes due to filtering.

I add a pic to see the ideal functioning. Notice how Table 2 goes up on the the right side view.

Thanks.

[Gysbert_Wassenaar · Accepted solution]

See attached example.

[christian77]

Hi G Wassennar.

You went by number of rows. Great!

The visibility of the 3rd table is under control.

I hope it works on-line.

Thanks a lot.

[christian77]

Hi.

Thanks again.

I like the way you count records from a table. My tables are pivot; I'll have to add total rows. I'ts a small hierarchy with 3 main totals. I'll figure out the space they take in rows.

By the way have you ever found out the relation between pixels (or points) in the screen and pixels inside VB module.

Well that's 0.32.

Points in VB * 0.32 = Points in QlikView screen (or the ones are shown in Title tab of objects)

msgbox pos.height * 0.32

Bye.

[christian77]

Hi Gysbert,

I found a little problem. Everything works fine except when I use the buttons One Step Back or One Step Forward. For Clear All works. That means Clear All is doing a selection or a change to shoot my triggers. Not the other 2. Can we consider that as a bug? Why those 2 don't act as selections. They really do change selections, that's exactly what they do.

Any suggestion?

Thanks.