topic Hide fields in Current Selection Box in QlikView

Hide fields in Current Selection Box

Wed, 06 May 2009 20:51:35 GMT

Hi All,

I want to hide some unwanted fields from the current selection box. Is there any way to do that.?

Currenty I am using inline load to include fields in the condition exxpression in the chart. I want these, not to displayed in the current selection box.

See the attached file. I dont want the field 'Chart', to be displayed in the current selection box.

Hide fields in Current Selection Box

Anonymous — Wed, 06 May 2009 21:03:38 GMT

That's easy...
Use HidePrefix to identify fields that start from a specified character (or string) as the system fields, and then hide system fields.

Hide fields in Current Selection Box

Wed, 06 May 2009 21:17:01 GMT

Hi Michael, Thanks for your reply.

But can you please explain me how to do that. It would be great, if you can modify the attached QVW file.

Hide fields in Current Selection Box

rbecher — Wed, 06 May 2009 22:49:11 GMT

Hi,

you can use a textbox with the choice of field selections you want like this:

='Selections:'&'\nCountry :'&getfieldselections(country)&'\nAmount: '&getfieldselections(Amount)

Hide fields in Current Selection Box

Anonymous — Wed, 06 May 2009 23:35:23 GMT

Simple example attched.
Statement
SET HidePrefix = %;
makes all fields starting with % the system fields. You also have to go to sheet properteis - fields tab, and uncheck the box "show system fields" after you bring the %C on th screen.
If you make selection in field %C - it's not in the current selections.

Hide fields in Current Selection Box

Thu, 07 May 2009 02:23:57 GMT

Thanks Micheal and Ralf for your solutions and it works for me.

Hide fields in Current Selection Box

johnw — Thu, 07 May 2009 02:28:15 GMT

Agreed. I'd never heard of the HidePrefix before, and had only used Ralf's solution in the past. There's enough complexity in the cases where I've done it that the HidePrefix won't solve my own problems, but I might certainly find use of it in the future. Thanks for pointing it out, Michael.

Re: Hide fields in Current Selection Box

Anonymous — Wed, 25 May 2016 08:47:46 GMT

Thanks for the best solution.