topic Re: Scrolling start position in chart? in QlikView

Scrolling start position in chart?

Anonymous — Tue, 15 Apr 2014 14:41:06 GMT

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

Re: Scrolling start position in chart?

MK_QSL — Tue, 15 Apr 2014 15:01:47 GMT

Layout Tab >> Preserve Scroll Position

Re: Scrolling start position in chart?

Tue, 15 Apr 2014 15:03:13 GMT

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

Re: Scrolling start position in chart?

richard_pearce6 — Tue, 15 Apr 2014 15:03:45 GMT

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

Re: Scrolling start position in chart?

richard_pearce6 — Tue, 15 Apr 2014 15:04:26 GMT

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

Re: Scrolling start position in chart?

richard_pearce6 — Tue, 15 Apr 2014 15:06:51 GMT

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

Re: Scrolling start position in chart?

Anonymous — Wed, 16 Apr 2014 07:19:25 GMT

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...

Re: Scrolling start position in chart?

Anonymous — Tue, 13 May 2014 07:45:27 GMT

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

Re: Scrolling start position in chart?

bnichol — Tue, 20 Oct 2015 19:01:00 GMT

Did you ever find an answer?

Thanks,

Re: Scrolling start position in chart?

Anonymous — Wed, 21 Oct 2015 06:30:54 GMT

Unfortunately not.

Re: Scrolling start position in chart?

bnichol — Thu, 29 Oct 2015 14:15:55 GMT

The 'Reversed' check box in the Chart Scrolling section accomplishes right scroll-bar allignment.

Re: Scrolling start position in chart?

jpapador — Thu, 29 Oct 2015 14:31:11 GMT

The reversed, check box in your original screenshot should do what you are asking for.

Re: Scrolling start position in chart?

swuehl — Thu, 29 Oct 2015 14:37:49 GMT

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.

Re: Scrolling start position in chart?

Anonymous — Fri, 30 Oct 2015 07:53:21 GMT

Tried to run this macro on my chart object (CH***) but unfortunately it didn't happen anything...

Re: Scrolling start position in chart?

swuehl — Fri, 30 Oct 2015 11:42:24 GMT

It's working for me with attached sample app.

If you open the app,you should see the upper chart scrolled to the right, the lower chart starts left by default.

You can change the setting of the upper chart by using the two buttons, but I think you need to save and reopen to see the change (it's an XScrollInitRight property).

I noticed another thread that reports issues with scroll bar settings in latest SRs, so just to check, on which QV version are you?

Re: Scrolling start position in chart?

Anonymous — Fri, 30 Oct 2015 13:58:26 GMT

Thank you a lot, it works!

Just had to save and reopen the document. Works great om QV 11.20 SR6.

Have a nice weekend!

Best regards,
Filip

Re: Scrolling start position in chart?

slondono — Thu, 07 Jul 2016 13:16:05 GMT

It works for me

Re: Scrolling start position in chart?

Mon, 29 Aug 2016 09:44:49 GMT

Thanks Stefan,

Recently, I also found out how to solve the problem "scrolling from the right". It works, great!

I copy the the macro you proposed into my qvw, and setup Document Properties/ Triggers/ Document Event Triggers/ OnOpen/ Edit Action/ Actions- Run Macro / Edit Module/Macro Name: "StartScrollRight"; it works!

thanks!

William