topic Exclude field from current selections box in QlikView

Exclude field from current selections box

Mon, 21 Dec 2009 17:04:19 GMT

Hi,

Is it possible to omit one or more fields from the Current Selections box? I have some LED List boxes where the user chooses which group of charts to display. These selections only clutter up the current selections box and do not affect the displayed data in any way.

/Niclas

Exclude field from current selections box

Fri, 25 Dec 2009 03:53:13 GMT

One way to do this is to name the fields you want to hide in the same way, for example all starting with %, then in your loading script put in

Set hideprefix='%';

after reload, open any chart properties and uncheck "Show system fields" at the bottom of the Dimensions tab and click OK to save the change.

By doing this, all fields with names starting with % are considered to be system fields and will not show up in current selection

Exclude field from current selections box

Mon, 28 Dec 2009 17:03:36 GMT

Awesome, worked like a charm.

Thanks a lot.