topic Re: Dynamic position change in QlikView

Dynamic position change

Anonymous — Tue, 05 Aug 2014 03:28:51 GMT

Is it possible to change X and Y coordinates dynamically in a chart so that keep always distance between two objects/charts constant irrespective of data present.

Re: Dynamic position change

avinashelite — Tue, 05 Aug 2014 03:53:28 GMT

Hi Praveena,

Its not possible in Qlikview ...Try with Macro.

Re: Dynamic position change

jagan — Tue, 05 Aug 2014 04:24:49 GMT

Hi Praveena,

It is not possible in Qlikview, you can try with Macro. Instead you can use two similar charts placing at different positions by showing and hiding based on your requirement.

But using Macro you will have lot of issues, I suggest using two charts.

Regards,

Jagan.

Re: Dynamic position change

ashfaq_haseeb — Tue, 05 Aug 2014 05:16:05 GMT

Hi,

Not possible directly, but can be done via macro.

have a look at the attached application.

Regards

ASHFAQ

Re: Dynamic position change

jagan — Tue, 05 Aug 2014 05:35:32 GMT

Hi,

Try this macro

** move chart object 20 pixels down and 15 right **

Sub MoveChart

set obj = ActiveDocument.GetSheetObject("CH09")

pos = obj.GetRect

pos.Top = pos.Top + 20

pos.Left = pos.Left + 15

obj.SetRect pos

End Sub

Regards,

Jagan.