Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
rdsuperlike
Creator
Creator

Current selection box- hiding a column

Hi,

Is there a way to hide a column from appearing in the current selection box?

Ny input is appreciated.

thanks

Labels (1)
6 Replies
MarcoWedel
MVP
MVP

Hi,

you could deselect the Values and/or Status column in the current selection box properties:

QlikCommunity_Thread_165635_Pic1.JPG

QlikCommunity_Thread_165635_Pic2.JPG

QlikCommunity_Thread_165635_Pic3.JPG

hope this helps

regards

Marco

rdsuperlike
Creator
Creator
Author

Ok. But if I want Code and customer to be displayed as it is and hide amount column from appearing in current selection box?

Colin-Albert
Partner - Champion
Partner - Champion

TAG the field as $hidden in your load script.

TAG field your_field_name with $hidden ;

TAG field amount with $hidden ;

rwunderlich
MVP
MVP

I perhaps you mean hiding a Field? Hidden fields will not appear in the Current Selections box. You make a field hidden either by using the SET HidePrefix or HideSuffix variable, or script:

TAG FIELD myfield with '$hidden';

-Rob

http://masterssummit.com

http://robwunderlich.com

rdsuperlike
Creator
Creator
Author

can you post one small sample?

rwunderlich
MVP
MVP

Try the attached example. Note that selections made in Fields "_Key1" and "X" do not show up in the Current Selections box. See the script to understand how it's done.

-Rob