topic Re: Added field to script - this is marked as $hidden. Why? in QlikView

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

Tue, 24 Sep 2013 09:23:55 GMT

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

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

swuehl — Tue, 24 Sep 2013 12:18:41 GMT

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.

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

bobdawes — Tue, 24 Sep 2013 12:24:59 GMT

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

Example: SET HidePrefix = '_';

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

AbhijitBansode — Tue, 24 Sep 2013 12:25:57 GMT

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

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

Tue, 24 Sep 2013 12:30:24 GMT

if you add field in script.

then write this

load *,

'test' as flag

from table;

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

Anonymous — Tue, 24 Sep 2013 13:00:17 GMT

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

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

Cheers,

Antoine

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

israrkhan — Tue, 24 Sep 2013 13:14:14 GMT

check this link.

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

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

markmccoid — Tue, 24 Sep 2013 13:16:19 GMT

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.

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

Clever_Anjos — Tue, 24 Sep 2013 13:31:35 GMT

What´s the name of your field?

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

Thu, 26 Sep 2013 10:01:00 GMT

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

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

Thu, 26 Sep 2013 12:48:48 GMT

I found the HidePrefix and understood how it's working .

There's a seperate script running and prefixing all fields with '_', except those mentioned in a reference table (Excel sheet). Added the new field to the table, load is currently still in progress but I believe it is working now,

Thanks for your help!

Jens