topic Re: Current selection box- hiding a column in QlikView

Current selection box- hiding a column

rdsuperlike — Tue, 26 May 2015 21:57:22 GMT

Hi,

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

Ny input is appreciated.

thanks

Re: Current selection box- hiding a column

MarcoWedel — Tue, 26 May 2015 22:10:22 GMT

Hi,

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

hope this helps

regards

Marco

Re: Current selection box- hiding a column

rdsuperlike — Tue, 26 May 2015 22:14:51 GMT

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

Re: Current selection box- hiding a column

Colin-Albert — Tue, 26 May 2015 22:16:45 GMT

TAG the field as $hidden in your load script.

TAG field your_field_name with $hidden ;

TAG field amount with $hidden ;

Re: Current selection box- hiding a column

rwunderlich — Tue, 26 May 2015 22:16:58 GMT

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

Re: Current selection box- hiding a column

rdsuperlike — Tue, 26 May 2015 22:20:19 GMT

can you post one small sample?

Re: Current selection box- hiding a column

rwunderlich — Tue, 26 May 2015 23:15:38 GMT

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