topic Bar Chart Horizontal Scroll Bar Moving on Filter Change in QlikView

Bar Chart Horizontal Scroll Bar Moving on Filter Change

brettaustin — Sat, 16 Nov 2024 18:11:47 GMT

Hello Team

I have a Bar Chart with a horizontal scroll bar (limit to 5 viewed at a time) with the dimension being the report date. When I change the Team I am viewing, the Months currently viewed on the visual changes to a different month.

Current Issue:

Selected Filter: Team A
Visible months: Jan - May
Change Filter: Team E
Visible months: Oct - Feb <==== Should be Jan - May

This is highly annoying when presenting the dashboard to management. Any thoughts on how you would keep the current (or highest month) from changing?

Desired Outcome:

Selected Filter: Team A
Visible months: Jan - May
Change Filter: Team E
Visible months: Jan - May

Re: Bar Chart Horizontal Scroll Bar Moving on Filter Change

Brett_Bleess — Tue, 08 Sep 2020 16:16:25 GMT

The only workaround of which I can think is to use bookmarks instead of what you are attempting to do currently. I am not sure whether the bookmark stores the scrollbar locations though, so that may be limitation there. I would recommend checking the Help doc to see exactly how things are designed to work there, so you know what the expected functionality should be versus what you are seeing...

https://help.qlik.com/en-US/qlikview/April2020/Content/QV_HelpSites/Home.htm

More specifically:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Bar_Chart.htm#anchor-21

It looks like the positioning should be maintained, but likely need the QVW file or a sample to look at things to be sure you have not done something else that is causing the issue to occur.

Regards,
Brett

Re: Bar Chart Horizontal Scroll Bar Moving on Filter Change

brettaustin — Tue, 08 Sep 2020 23:16:32 GMT

HI Brett (great name btw)

It appears that after mindless hours and pain, I figured out a resolution. As to why Qlikview behaves in the manner it does, I have no clue.

Solution:

1. Sort:

1a. unclick 'State' as sort

1b. Numeric: Descending

2. Presentation (Chart Scrolling): Unclick 'Reverse'

See attached - Thank you for your assistance!

Brett