Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a bar chart that has the following property selected in the presentation tab:
it loads with the bottom scroll bars right justified but the moment a filter is selected, the scroll bar either moves to the center or the extreme left. This is really annoying behavior.
1. I am using 11.2 version Qlikview.
2. I have tried using a macro to move the scroll bar to the right but that does not work
Macro:
Sub SetScrollRight
set chart1 = ActiveDocument.GetSheetObject("CH06")
set p1 = chart1.GetProperties
p1.ChartProperties.XScrollInitRight = true
chart1.SetProperties p1
End sub
I am running out of options and need some help.
I have also tried the following on the Layout tab:
still no luck
Hey coolhawk,
Those are the three settings you need to use to get the desired outcome. I have found that scroll bar settings on bar charts have been a bit buggy in the past few SRs. For example, I have also noticed that changing "scroll style" on the layout tab doesn't always work until you change the scrollbar width as well.
Having said that, I did just try to recreate the issue and didn't run into the same problem. What SR are you on?
Have you tried publishing these changes to the web? Wouldn't be totally surprised if the scroll worked fine. Might just be a QV Desktop issue
David,
Unfortunately the issue is global and has been seen on the browser as well.
OK - what Service Release are you on? Maybe an upgrade is in order.
Also try changing the 'style' of the chart to be a horizontal bar chart so the scroll goes top to bottom (or bottom to top on the reverse). I find that user generally like these better anyway.