To Clarify, in the below example the box represents the range of values in field SEGMENT I want to display in my chart. "Next" and "Prev" Button should move the set in the box up or down the sequence -- note that there are missing values in the range. Assumption in this example is vSegmentInterval = 4.
On looking at this again I now believe my "Next" Button Expression is incorrect as well. Although it is taking me to the next set of SEGMENTS, it is actually deselecting the previous SEGMENTS, rather than just moving my window to display the next set. Next and Prev Button should only be a rolling window over the selected set of SEGMENTS, it should not be deselecting any values. Is this even doable?
Should work similar to scrolling. Reason for this implementation is I have layered bar charts that must scroll in unisom; as there is no Qlikview built in methodology to tie the X-Axis from multiple charts together I had to resort to this implementation. In addition to the "Prev" and "Next" Buttons I have a Slider based off of the common X-Axis. It works slightly better than my Next and Prev Buttons, but it also gets confused when the slider hits a missing SEGMENT and like the Next and Prev Buttons is also selecting and deselecting SEGMENTS to accomplish the scroll rather than providing a moving window over the SEGMENTS.
Message was edited by: Lew Goldstein
Digging through other Discussions I found an Expression I was able to leverage that works for my "Prev Button" when an empty set exists in the date range:
I must admit I don't totally follow the logic here, but it works; except in cases when multiple consecutive empty sets. Hoping to get better understanding of this expression so I can make it work for "Next Button" as well.