Solved: Scrolling start position in chart? - Qlik Community

Anonymous · ‎2014-04-15

Hi there,

Is it possible to set a start position for a scroll bar in a chart object? (line chart)

Please see my attached images. As you can see, my x-axis dimension consists of periods, and I want to have the scroll bar placed to the right as default when I open the QlikView document. I have used the chart scroll setting (also attached) och the Presentation tab in the object. I thought it would be nice to see the last 12 months, but i don't want to reverse my dimension as getting the latest period to the left makes no sense.

I also read about the "Preverse scroll position" setting on the Layout tab, but that couldn't help me... Is it possible to get a solution to this slight problem?

Thanks in advance.

Best regards,

Filip

swuehl · ‎2015-10-29

There is a way to set the initial position to right.

You need to create a Macro, and run it once. After that you can delete the Macro, the chart property will be kept changed.

The Macro code looks like

SUB StartScrollRight

SET chartObject = ActiveDocument.GetSheetObject("CH01")

SET chartProperties = chartObject.GetProperties

chartProperties.ChartProperties.XScrollInitRight = true

chartObject.SetProperties chartProperties

END SUB

You'll need to adapt the Chart ID. Run the Macro e.g. from a button.

View solution in original post

MK_QSL · ‎2014-04-15

Layout Tab >> Preserve Scroll Position

Report Inappropriate Content · ‎2014-04-15

You can create a bookmark/ It's also possible to save scroll position

richard_pearce6 · ‎2014-04-15

Hi,

I'd like to know the answer to this questions too.

One thing I did recently is to create a class() field on the date and used a variable attached to a slider to control the interval.

Using a combination of this and chart scrolling 'when number of items exceeds' the first view a users sees has no scroll and then they have the option with the slider to show greater detail and therefore more dates.

It worked for my requirements although you are now aggregating the data when you're not at the lowest level which may not suit your needs.

I look forward to hearing a solution.

Richard

QlikCentral.com

richard_pearce6 · ‎2014-04-15

I tried the bookmark option and it didn't work for chart scrolls

richard_pearce6 · ‎2014-04-15

I also tried the layout option and that didn't seem to work

Anonymous · ‎2014-04-16

Back to my original question,

Is it possible to set a start position for a scroll bar in a chart object?

I don't want to use bookmarks and as I wrote in my post, "Preserve Scroll Position" doesn't help me...

Anonymous · ‎2014-05-13

Is there nobody who knows a solution to this problem? Is it not possible?

bnichol · ‎2015-10-20

Did you ever find an answer?

Thanks,

B

Anonymous · ‎2015-10-21

Unfortunately not.