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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section Access - Omit by default

Hey Everyone,

My questions is in regards to section access.  Using the example below I can omit fields to certain users.  My example was found here: Qlik Tips: Blocking user access to a field using OMIT

Section Access;

LOAD * INLINE [

    ACCESS, USERID, OMITGROUP

    ADMIN, admin,

    USER, user1, group1

    USER, user2, group2

];


LOAD * INLINE [

    OMITGROUP, OMIT

    group1, Field1

    group1, Field2

    group2, Field2

    group2, Field3

];

My scenario is a little bit different though.  Say I want to omit a field for all users, and show it only for an explicit list of users.  Is there a way to do this?

For example I have 3 users, and only one should be able to see cost information.  In this case I want to list the 1 user that can see the cost information and the other two would have this column ommitted.  If a fourth user was added that new user would automatically have cost ommitted without having to update the section access.

Thanks in advance.

Labels (1)
1 Reply
Bill_Britt
Former Employee
Former Employee


You could do this by using Windows Groups. Doing the same thing you are doing now, but using group membership.

Bill

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.