topic Re: Current Selection Box - Field exclusion in QlikView

Current Selection Box - Field exclusion

Fri, 28 Feb 2014 09:49:24 GMT

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

Re: Current Selection Box - Field exclusion

Fri, 28 Feb 2014 09:52:03 GMT

Re: Current Selection Box - Field exclusion

Fri, 28 Feb 2014 09:59:30 GMT

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

Re: Current Selection Box - Field exclusion

Jason_Michaelides — Fri, 28 Feb 2014 10:02:37 GMT

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

Re: Current Selection Box - Field exclusion

Fri, 28 Feb 2014 10:06:11 GMT

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

Re: Current Selection Box - Field exclusion

sunilkumarqv — Fri, 28 Feb 2014 10:09:53 GMT

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