Added field to script - this is marked as $hidden. Why?

[#1]

Hi all,

I'm rather new to Qlikview, did a mixture of Designer/Developer training some time ago and now I work in a QV project for the first time.

My current task is to add a new field to an existing load script and display the field on the front end. So far so good, the source qvd file contains the new field, I enhanced the load command in the script that loads from the qvd and the new field is available,

BUT it is marked as $hidden and an underscore is prefixed. No idea why. So I have to check "Show System fields" to be able to add the field to my chart.

What might be the issue?

Thanks, Regards,

Jens

[swuehl]

Search your script for something like

SET HidePrefix = '_';

From the HELP:

All field names beginning with this text string will be hidden in the same manner as the system fields. A user-defined variable.

Example:

set HidePrefix='_' ;

If this statement is used, the field names beginning with an underscore will not be shown in the field name lists when the system fields are hidden.

[bobdawes · Accepted solution]

Jens, your script may use HidePrefix, in which a character is set as the prefix for hidden fields.

Example:  SET HidePrefix = '_';

[AbhijitBansode]

Reason might be:

underscore ''_'' is set as HidePrefix in your script.

Look for the statement SET HediPrefix = '_' ;

And since your fieldname starts with underscore, it will be hidden in the UI unless you check 'Show System Field' .

[#5]

hi

if you add field in script.

then write this

load *,

'test'  as flag

from table;

[Anonymous]

Your field has a prefix _? What is your fieldname?

Check in your setting that you might have SET HidePrefix ='_' or SET HideSuffix

Cheers,

Antoine

[israrkhan]

check this link.

http://community.qlik.com/message/13275#13275

[markmccoid]

There is a Qlikview keyword "HidePrefix" that will hide fields unless the "Show System Fields" is checked.

You will see this at the beginning of the script designating what prefix will cause a field to be hidden:

HidePrefix = '%';

Many times this is used to hide fields, like Keys and IDs, from end users creating reports so as to not clutter the Dimension list with fields that are not used in charts.

[Clever_Anjos]

What´s the name of your field?

[#10]

The field is called PRODUCT_COMMITMENT_NUMBER.

So far, I didn't find a "Set HidePrefix" or something similar. I'll have another look now,

Thanks

Jens