The selection can be hidden on all sheets or no sheets (from a current selection box). You can explore alternatives to using current selection box to view current selections here -> Current Selection Alternatives
or if hidding it on all tabs are acceptable, then check out this link -> HidePrefix – hiding fields
You can use HidePrefix variable in the script
If you like that a field don't show in selections use % in front of him in the script.
Load * Inline [
Field A never leave in the selection, but if you need to leave in a pivot or graphics have to put Show system Fields.
Test.qvw 148.0 K
This solution is what I'm looking for, but it works only with one selected item. Can someone help me to find a solution for more selected items?
When I select two companies in filter 'Company' I want to see in my current selection box of alternate state 'PlanningControl' this two companies. With below settings it presents nothing.
When I select only company 'EZCAN' it presents the right selection.
Below the document settings, sheet Triggers, field Company.