Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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

6 Replies
MarcoWedel

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

TAG the field as $hidden in your load script.

TAG field your_field_name with $hidden ;

TAG field amount with $hidden ;

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/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
Partner Ambassador/MVP
Partner Ambassador/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