topic x-axis scroll bar to keep right by default in QlikView

x-axis scroll bar to keep right by default

Tue, 13 Mar 2012 15:45:44 GMT

Hi - I have built a combo chart and set the max visible as 12 and enabled X-Axis scroll bar if it goes above 12 months. My sort order is date dimension with ascending order. All works well, but I am unable to keep the x-axis scroll bar to be always right by default. For ex, currenly if I close and open up the qvw file then you can see the scroll bar going back to left and use can scroll through to the right. But I need it by default to be at the right side as shown in the screen shot. Is there anyway we can do this? If so, any idea pl?

x-axis scroll bar to keep right by default

Tue, 13 Mar 2012 15:51:04 GMT

x-axis scroll bar to keep right by default

Wed, 09 May 2012 15:15:21 GMT

I'm not sure what version you are using but on 11 under the presentation tab of the chart properties there is a "Reversed" check box in the chart scrolling section that should do as you need.

This works on screen but not on reports as of yet.

x-axis scroll bar to keep right by default

m_woolf — Wed, 09 May 2012 17:15:01 GMT

This code will look at all objects on all sheets, and if the object ID is in strSearch, it will set the scroll bar to the right.

sub ChartXScrollInitRight

stop

s=ActiveDocument.NoOfSheets

for i = 0 to s-1

set s=ActiveDocument.Sheets(i)

objs=s.GetSheetObjects

for j=lbound(objs) to ubound(objs)

strCHID = objs(j).GetObjectID

strSearch = "CH61,CH59,CH57,CH62,CH65,CH66,CH67,CH68,CH69"

intFound = instr(strSearch,mid(strCHID,10,4))

if intFound > 0 then

Set rep = ActiveDocument.GetSheetObject(strCHID)

set p = rep.GetProperties

p.ChartProperties.XScrollInitRight = True

rep.SetProperties p

Else

' Do nothing'

end if

end sub

x-axis scroll bar to keep right by default

Wed, 16 May 2012 14:55:39 GMT

Thanks both for your reply, we are now in QV 10, but soon we will be moving into 11 so will use the property as suggested instead of having macro. Thanks

Re: x-axis scroll bar to keep right by default

sujeetsingh — Tue, 23 Jul 2013 08:20:01 GMT

It did not work for me in Q11

Re: x-axis scroll bar to keep right by default

Tue, 23 Jul 2013 08:52:29 GMT

i am working in QV 10,Just x-axis scroll bar put in right and save it..hope it will work..

regards-bika

Re: x-axis scroll bar to keep right by default

Fri, 13 Sep 2013 15:26:32 GMT

Has anyone found a solution for this? I am working in QV 11.

Re: x-axis scroll bar to keep right by default

Tue, 24 Sep 2013 15:18:38 GMT

In QV 11, under the Presentation tab if you enable the X-Axis Scroll bar and also check the "Reversed" box it should work for you. My sort is based on date so setting Reversed has the charts default to the latest date or x-axis scroll bar to the far right

Re: x-axis scroll bar to keep right by default

sujeetsingh — Fri, 20 Jun 2014 09:37:14 GMT

What about Straight table and Pivot table

Re: x-axis scroll bar to keep right by default

mfikrirahmat — Wed, 20 Apr 2016 07:37:34 GMT

why doesn't work in chart type pivot table , have a solution ?

Thank's

Re: x-axis scroll bar to keep right by default

Mon, 25 Apr 2016 08:50:17 GMT

In the presentation tab, "Reversed" option should solve your problem

Re: x-axis scroll bar to keep right by default

Margaret — Thu, 18 Jan 2018 16:30:54 GMT

I'm in 12.1 and checking "Reversed" changes the sort of the values, it doesn't move the scrollbar.