Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

Current Selection Box - Field exclusion

Dear Community,

Is it possible to exclude certain fields from "Current Selection box"?

For example, user might not desire to look at field as shown below:

But they would like to see:

Thanks and best regards,

Chanel

1 Solution

Accepted Solutions
Not applicable

Re: Current Selection Box - Field exclusion

Maybe you are looking for this...

Exclude field from current selections box

5 Replies
Not applicable

Re: Current Selection Box - Field exclusion

Maybe you are looking for this...

Exclude field from current selections box

Not applicable

Re: Current Selection Box - Field exclusion

Thanks for your fast response.

From his reply:

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

Is it suitable for the case with Chart which has dimensions tab?

My field will be chosen from listbox, so i couldn't find "Show system fields"...

Best regards,

Chanel

jason_michaelid
Honored Contributor II

Re: Current Selection Box - Field exclusion

Create a dummy chart and select "show system fields" then delete the chart. Show System Fields will persist from then on and will be in your listbox field list.

Hope this helps,

Jason

Not applicable

Re: Current Selection Box - Field exclusion

Show System Fields can also be activated to show in all charts by checking the same under 'General' tab of 'User Preferences'

sunilkumarqv
Valued Contributor II

Re: Current Selection Box - Field exclusion

In Script as of the post i learnt that

Use

Set hideprefix='%'; and make a not which ever the field you want to exclude '%'Replace with Field Name

then reload . i.e (Set hideprefix='FieldNames';)

I tried it in my Doc its worked  hope you get the solutions