Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Can you Omit specific data of fields with section access?

Hello community:

I'm trying to build a section access for my project and I'm trying to do something that so far hasn't work yet and I'm having doubts if it even can be done.

I have the following Users: ADMIN and USER

What I want to do, is restrict 'USER' to see the sales Department, so I tried the following sentence:

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, OMIT

    ADMIN, CEO, CEO123

    USER, user, user123, DEPARTMENT='SALES DEPARTMENT'

];

Section Application;

So far it hasn't work, so, is there another way to do it?

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try this instead:

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, DEPARTMENT

    ADMIN, CEO, CEO123

    USER, user, user123, SALES DEPARTMENT

];

For more information see:

A Primer on Section Access

Section Access


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try this instead:

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, DEPARTMENT

    ADMIN, CEO, CEO123

    USER, user, user123, SALES DEPARTMENT

];

For more information see:

A Primer on Section Access

Section Access


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

it worked!

Thank you very much indeed!