The green dot that appears in the tab, next to the Title of the sheet, is an indicator that one or more Field-Selections (filters) on that sheet are in effect. The dot appears for only tabs that are not currently active/open.
From the QlikView Help documentation:
Indicator
Indicators (or beacons) are colored dots that sometimes appear on tabs and in the right-hand corner of the status bar. Indicators are there simply to remind you of selections that have been made in fields that are not available on the sheet that you are currently viewing. Since all sheets of a QlikView document are fully interconnected at all times, such selections will most likely affect what is displayed on the active sheet - even when they are not immediately apparent! This is the main reason for having indicators.
I do disagree with the statement "all sheets are fully interconnected at all times". Take, for example, SheetA and SheetB, whose data are completely separate by a different data-clouds. They do not share the same set of fields, therefore they are not "interconnected" in this sense.
An easy way to see the green dot indicator is to copy one sheet to form a new one. In the example where SheetA and SheetB are both populated with non "Read Only" objects, if we...
1. select in SheetB one field
2. copy SheetB
2. rename it to SheetC
3. activate SheetC by clicking on the new tab
...the result is SheetB showing the green dot.
This is apparently telling us that, "hey, even though SheetB is no longer active, the field-selection there is still active and has carried over to SheetC".
Similiarly, if we now choose in SheetC a new value to filter on, the green dot in SheetB's tab is telling us that, "hey, even though SheetB is no longer active, you might want to know that your field-selection in SheetC is causing a filter to be in effect, in the background, at SheetB".
If we reactivate SheetB, the green dot disappears for SheetB, but now appears for SheetC. This gives the impression that the two tabs are "linked"... and in this case they are interconnected, by the columns they have in common, from the same data-cloud. But if we activate SheetA, all dots disappear, telling us "no related, lingering filters are in effect in the background".
If you wish to suppress this behavior, I am not aware of any settings to instruct QlikView to stop indicating that background field-selections are in effect. You do have two options, though, that might give you some control over field-selection, when you change activation from one sheet to another:
1. Modify the Sheet Properties and, in the Sheet Event Trigger, add an Action for the "OnLeaveSheet" event. Add "Selection!Clear All". (The sheets are still "linked", by their common columns. As soon as you perform a new field-selection in one sheet, the green dot will appear in the other linked sheet.)
2. Move to a different data-cloud the data for the second sheet, by copying the data-load statements in the script, and giving alternative names to the set of columns. (The sheets are no longer "linked"; their field names are unique. Performing a field-selection in one sheet will not result in the green dot appearing in the other.)
Key words: Tabrow Green Dot Indicator Sheet Tab
