Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Highlighted
Not applicable

Re: Current Selection Box - Field exclusion

5 Replies
Highlighted
Not applicable

Re: Current Selection Box - Field exclusion

Highlighted
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

Highlighted
Partner
Partner

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

Highlighted
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'

Highlighted
Specialist II
Specialist 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