Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Hide selection in current selection box

How to hide selection 'Year' in my current selection box?

This year selection (2015 t/m 2018) is used in other sheets. In below sheet selection 'Season actual' is used (201404; alternate state).

For the user it is confusing they see selection 'Year'.    

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

5 Replies
sunny_talwar

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

sorrakis01
Specialist
Specialist

Hi,

You can use HidePrefix variable in the script

set hideprefix=%;

If you like that a field don't show in selections use % in front of him in the script.

Example:

Load * Inline [

%A,B

1,2

];

Field A never leave in the selection, but if you need to leave in a pivot or graphics have to put Show system Fields.

Prove it.


Regards,

maxgro
MVP
MVP

Another one could be

TAG field Year With $hidden;

Anonymous
Not applicable
Author

Alternate States - Apply Filter from one to the Other

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.    

Anonymous
Not applicable
Author

Solved it with posts:Copy Selections from one field to another and

HidePrefix – hiding fields (hide field __Year_Temp)