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

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

julioarriaga — Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 01 Aug 2017 16:40:31 GMT

Look for

set HidePrefix='%' ;

in the script and delete it.

ziadm — Tue, 01 Aug 2017 16:50:41 GMT

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

remark the

set HidePrefix='%' ;

julioarriaga — Tue, 01 Aug 2017 18:16:46 GMT

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

asifmaula2015 — Sat, 22 May 2021 02:54:05 GMT

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.