Why does a field starting with % doesn't appear in my Field List?

[julioarriaga]

Hi everyone,

In advance I apologize for the rookie question and I want to thank you for patience.

I extracted a model through a Binary and I fabricated a new table (Image 1). Why is the "%Date Key" field not usable for my objects in QV?

Roughly speaking, I'm assuming that it has something to do with Link Tables but I can get my head around this concept.

Thanks.

(Image 1 - Code of fabrication for my table -I ommitted the Binary statement-)

(Image 2 - Original Model that I extracted from the Binary)

(Image 3 - New table created in my application)

(Image 4 - Fields available for use in my objects)

[tomasz_tru · Accepted solution]

Look for

set HidePrefix='%' ;

in the script and delete it.

[ziadm]

This % Feature is to hide any field and mostly used for Key Fields. 

remark the

set HidePrefix='%' ;

[julioarriaga]

Thanks for your reply. Why would you want to hide Key Fields?

[asifmaula2015]

Because Keys are not data. Key Fields in a Qlikview model should serve the data modeler, and not be used by chart Designers as data.