Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
grassomirco
New Contributor II

OMIT Section Access do not hide key fields

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

2 Replies
Gabriel
Valued Contributor II

Re: OMIT Section Access do not hide key fields

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.

grassomirco
New Contributor II

Re: OMIT Section Access do not hide key fields

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.

Community Browser