topic Macro to Scroll a bar chart to its right in QlikView

Macro to Scroll a bar chart to its right

Wed, 03 Sep 2014 08:38:55 GMT

Hi,

Do we have a macro to scroll the scroll bar position to the right most corner?

I have created a Qlikview report with a bar chart which will be exported as an image every month automatically. But, once each month's data gets added, I need the scroll bar position to be at the rightmost point (in order to accommodate the newly added month).

It would be handy to have a macro script which can do that. Can any one please help me out.

Regards,

Mithun

Re: Macro to Scroll a bar chart to its right

ashfaq_haseeb — Wed, 03 Sep 2014 09:26:12 GMT

Hi,

Check if this help

Sub SetScrollRight
 set chart1 = ActiveDocument.GetSheetObject("CH06")
 set p1 = chart1.GetProperties
 p1.ChartProperties.XScrollInitRight = true
 chart1.SetProperties p1
End sub

Regards

ASHFAQ

Re: Re: Macro to Scroll a bar chart to its right

Wed, 03 Sep 2014 09:50:38 GMT

Hi Ashfaq,

Thank you for your reply! I have already tried this command, but without success.

The scroll bar does not change its position. PFA my test document.

Regards,

Mithun

Re: Re: Re: Macro to Scroll a bar chart to its right

ashfaq_haseeb — Wed, 03 Sep 2014 10:52:00 GMT

Hi,

Its working as expected.

Have a look at attached alternate solution without macro.

Regards

ASHFAQ