topic Re: OMIT Section Access do not hide key fields in QlikView

OMIT Section Access do not hide key fields

grassomirco — Mon, 26 Jan 2026 18:19:17 GMT

Hello everyone

I'm tring to hide an entire qualified table with the Section Access.I am not able to hide the primary key. Is there a way to do it? Am I doing something wrong?

---------- Script Qlik ------------

[TableToRemove]:

xx_Field1,

xx_Field2,

xx_Field3,

xx_keyField

FROM

...

----------------------------------------

------------ Section Access Txt -----------------

ACCESS;USERID;USER;PASSWORD;NTNAME; OMIT

ADMIN; User1; User1; User1; NTName1; xx_*

....

--------------------------------------------------------------

What I find after reloading data is [TableToRemove] is the table with only xx_keyField.

I want to hide ALL the table.

Thanks

Mirco

Re: OMIT Section Access do not hide key fields

Gabriel — Thu, 21 May 2015 15:45:05 GMT

Hi,

OMIT will not hide the table for you.

You should have to do the following

SECTION ACCESS;

Security Table Name

FIELD A

,FIELD B

FROM SOURCE;

SECTION APPLICATION

This will hide the table.

Hopefully I understand what you want to achieve.

Re: OMIT Section Access do not hide key fields

grassomirco — Fri, 22 May 2015 09:59:20 GMT

Hi Gabriel,

what I would like to do is hide all the fields on a specific table. With OMIT I can't omit the key field.

Unfortunately I haven't understood what you mean exactly.

Let's suppose I have to hide with the section access the table below:

TABLE:

LOAD

Tb_Field1,

Tb_Field2,

Tb_Field3,

Tb_keyField

FROM [source];

What should I text in my Section Access?

Section Access;

LOAD *

RESIDENT TABLE;

Section Application;

I am not sure it will work properly.