Hide columns

[#1]

Hi Gurus,

I have designed data model by joining OperatingUnit table with fact table which has opertg_unit_key as primary key column. But user doesnt want to see opertg_unit_key( key columns which used to join table ). By searching over youtube, i tried implementing following code, which doesnt work.

SET  HidePrefix = '~'
ODBC CONNECT32 TO [dw-xlre-am] (UserId is crystal, Password is password);
OperatingUnit:
LOAD OperatingUnitDesc,
     opertg_unit_key AS [~opertg_unit_key]
FROM
(qvd);

Could you please suggest me how to hide/Drop/remove column from the document.

Thanks in Advance.

Thanks,

Sherry

[sunny_talwar]

Where exactly are you trying to hide it from? From a specific table or from the database? Need more information before we can guide you in the right direction.

Best,

Sunny

[sinanozdemir · Accepted solution]

Hi Sharmila,

Here is my solution:

I used a different symbol, maybe QlikView doesn't like '~'. After that in the front end sheet properties, just uncheck "Show System Fields"

As you can see "Specialty" field is hidden.

Hope this helps.

[maxgro]

the problem in your script is you forget a ;

replace

SET  HidePrefix = '~'

with

SET  HidePrefix = '~';

some different way

1) HidePrefix (or HideSuffix), as you did in your script; from QlikView help

HidePrefix

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.

2) mapping table

you can add the description to fact table using a mapping load and applymap function

MapOperatingUnit:

mapping load 

opertg_unit_key, OperatingUnitDesc

FROM (qvd);

facttable:

load

     .......,

     ApplyMap ('MapOperatingUnit', opertg_unit_key ) as  OperatingUnitDesc,

     ......

from

     .......;

In 1 you have an hidden field, a fact table and a lookup table

In 2 you don't have the field and the lookup table, only the fact table

[svenkita]

if you want to drop a column from the data model use the following syntax

Drop Filed <FiledName> From <TableName>;

[#6]

Hi Sunny,

I was trying to Hide the System columns. Found answer from Sinan i am good now.

Thank you

Sharmila

[#7]

Thank you Ozdemir, I was able to get results using your solution.

Thank you,

Sharmila

[#8]

Thank you Grossi, i was able to fix the issue with your correction.

Thank you,

Sharmila