topic Re: Excluding fields from a Current Selections Box in QlikView

Excluding fields from a Current Selections Box

Mon, 18 Nov 2013 16:59:31 GMT

Within our application, we have several fields which are used to control navigaton and other flow within the application. These fields have no meaning to the application user and so can be confusing if displayed, How do we exclude these fields from the current selection box?

Here is what displays now. The field marked with a yellow highlighter is what we wish to exclude.

Re: Excluding fields from a Current Selections Box

MayilVahanan — Mon, 18 Nov 2013 17:02:21 GMT

Try like this

set HidePrefix = '%' ;

Then While load the field, rename as %FieldName;

Its hide the fieldname;

Re: Excluding fields from a Current Selections Box

Clever_Anjos — Mon, 18 Nov 2013 17:05:08 GMT

Tag ActiveSheet as $hidden

Re: Excluding fields from a Current Selections Box

rustyfishbones — Mon, 18 Nov 2013 17:07:19 GMT

Have you tried using alternate states

Re: Excluding fields from a Current Selections Box

pandiarajan — Mon, 18 Nov 2013 17:08:22 GMT

Dear Vahanan Ramasamy,

if i use set hide prefix with section access . my section access is not working. if i remove set hideprefix my section access working fine.

Re: Excluding fields from a Current Selections Box

pandiarajan — Mon, 18 Nov 2013 17:14:18 GMT

Dear Ken Jones,

try this

Sheet Properties -> Triggers - > Add action - > ADD - > ACtionType - > Selection - > Clear Field - > select the needful fields

Re: Excluding fields from a Current Selections Box

Mon, 18 Nov 2013 17:31:38 GMT

Hi Mayil,

When I added these to the script, it worked as specified. Thanks.

Ken

Re: Excluding fields from a Current Selections Box

Mon, 18 Nov 2013 17:36:37 GMT

When I try to do this in the script, I get and error on the "as" .. Should I be trying to accomplish this elsewhere?

Re: Excluding fields from a Current Selections Box

Clever_Anjos — Mon, 18 Nov 2013 17:38:33 GMT

Sorry no "as"

TAG Field yourfield $hidden;

Re: Excluding fields from a Current Selections Box

Mon, 18 Nov 2013 17:39:02 GMT

Unfortunately, clearing this field results in conditionally "hidden sheets" becoming visible ... and if we wanted that, we wouldn't need the "ActiveSheet" field. Thanks for the thought.

Re: Excluding fields from a Current Selections Box

Mon, 18 Nov 2013 17:43:21 GMT

This works and is IMO the best answer for my present situation. Thanks so much