Field not appearing in Available Fields selection area

[#1]

Hi there,

I have a field called "Flavor" which is not appearing in the list of available fields. See the image below.

when I change the check box for "Show System Fields", it will then appear. See image below:

Why is "Flavor" considered a "system field". It creates a problem for me because when I want to use a "Search Object" nothing in the "Flavor" field will come up in the search return even though the "search object properties" has the "all fields" radio button selected.

[#2]

Can you show us any of the load script relevant to the Flavor field?

Just as a wacky check, I tried creating my own 'Flavor' field in a sample document, and it's not the field name itself that's giving the issue (I know, wackie idea)

Have you considered renaming the field? Or changing its order in the load script?

[#3]

I guess I can change the order of the field but I certainly don't want to change the field name because I have a lot of variables in this document and I would have to manually change about 100+ things to enable this field name change.

VIPItemMaster:
LOAD Product_ID,
ITEMDESC,
UNITS,
SELLUNIT,
Brand as LongBrand,
//SKU,
CAT1 as [Flavor],
Category,
SubCategory as [Brand],
[Package Size],
CAT5 as [SKU]

FROM
$(QVDDir)\VIPItemMaster.qvd (qvd);

[#4]

I tried changing the order of the fields. Doesn't change anything to help it show up as an available field.

[stevedark]

Hi Mike,

It doesn't relate to your original query, but... if you do try renaming the field and update your variables you can do a global search and replace by selecting:

Settings
Expression Overview
Tick all boxes
Select Find/Replace

Also, if you change only the field name between two reloads then QlikView will sometimes notice the name change and update references to the field automagically - I wouldn't recommend relying on this though.

On the original issue, you can obviously force fields to be system only by using 'Set HidePrefix = '%';', is it possible that there is a HidePrefix statement for F or Flavor?

Regards,
Steve