topic Re: Relative object position in QlikView

Relative object position

Thu, 03 Jan 2013 12:03:57 GMT

Hi,

I have two pivot tables, one below the other. The one above can be longer or shorter but I need the other keeps allways the same distance to the other.

How can I get so?

Thanks a lot.

Re: Relative object position

khadeer — Thu, 03 Jan 2013 12:07:37 GMT

In Caption tab u have Xpos, YPos, height, Width.... Keep same for both.

Re: Relative object position

Thu, 03 Jan 2013 12:14:19 GMT

Sorry I made a horrible traslation, I meant I need to keep constant the distance between both tables, so the second one moves depending on the first one size.

Re: Relative object position

er_mohit — Thu, 03 Jan 2013 12:16:53 GMT

i can not get you exactly..can you explain it with attached image?

Re: Relative object position

Thu, 03 Jan 2013 12:27:37 GMT

For example , I want the table 'EBITDA' situated one centimeter below the table 'RESULTADOS' no matter how many rows can 'RESULTADOS' have. Allways one centimeter below.

Re: Relative object position

marcus_sommer — Fri, 04 Jan 2013 13:19:02 GMT

I think this is only possible per macro. Read the size from table1 and set table2 x pixels below. See the examples like below in APIGuide.qvw.

rem ** move all objects on active sheet 20 pixels down and 15 right **

set sh = ActiveDocument.ActiveSheet

for i = 0 to sh.NoOfSheetObjects-1

set obj = sh.SheetObjects(i)

pos = obj.GetRect

pos.Top = pos.Top + 20

pos.Left = pos.Left + 15

obj.SetRect pos

Marcus

Re: Relative object position

Fri, 04 Jan 2013 15:11:01 GMT

Thank you very much but is too complicated for me.

Is very dissapointing that QV are not able to do something so simple using basic user tools.

Thanks Marcus

Re: Relative object position

jburstin — Tue, 13 May 2014 21:54:51 GMT

Hi!

I had this issue too, and could resolve it with macro code bellow.

This code, evaluates the height of the table object, and sets the top of the graph that has to move its position depending on quantity of preceding rows.

It has worked fine for me, and hopes that help to you too..

Regards

Javier

Sub AjustaGrafico

set Tabla = ActiveDocument.GetSheetObject("CH03") 'Table

set Grafico = ActiveDocument.GetSheetObject("CH08") 'Graph

Set PosTabla = Tabla.GetRect

Set PosGrafico = Grafico.GetRect

Cabezal = 22

Pie = 10

Fila = 16 'cell.LineHeight

Cnt = Tabla.GetRowCount

Alto = Cabezal + Pie + (Cnt * Fila)

PosGrafico.Top = PosTabla.Top + Alto

Grafico.SetRect PosGrafico

End Sub

Re: Relative object position

qolkaram — Fri, 01 Nov 2019 20:00:24 GMT

Hi,

Sorry Guys to reply to this old post, but I'm wondering how to fix this issue in the web view. macro has solved the issue when using desktop , but when the report published on QlikView access point again charts positions are messed up.

Thanks

Nassim