Scroll bar set to right on change on cyclic group

Mon, 13 Jun 2011 10:33:21 GMT

Hello Experts,

I have a bar chart

X-axis : Cyclic group for data as ( Date, week, period)

Y-axis : Country Dimension

Measure : Sales.

I have written a macro to set the scroll bar right when you open the report. Its working as desired. But when you change the cyclic group from Period to Week or date, the scroll bar seems to set at some default location , but not towards the right.

Could any one suggest on this?

/*********************************************/

Sub SetScrollRight

set chart1 = ActiveDocument.GetSheetObject("CH42")

set p1 = chart1.GetProperties

p1.ChartProperties.XScrollInitRight = true

chart1.SetProperties p1

End sub

/*********************************************/

Regards

Vinod

topic Scroll bar set to right on change on cyclic group in QlikView

Scroll bar set to right on change on cyclic group