Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
sunny_talwar

Section Access change of roles from ADMIN to USER

Hello All -

I have a weird section access question, which I hope someone can share some light on. I am working on a dashboard where I wanted to test section access for a user. So, I decided that I will test it under my name (as USER) and then revert back to ADMIN.

I ran the script with this

Section Access;

LOAD ACCESS,

Upper(NTNAME) as NTNAME,

Text(SECTION_ACCESS_FIELD) as SECTION_ACCESS_FIELD;

LOAD * INLINE [

    ACCESS, NTNAME, SECTION_ACCESS_FIELD

    USER, domain\talwar, ABC

    ADMIN, domain\qlikview, *

];

Section Application;

Running the above worked beautifully and it just gave me access to rows related to ABC.

Once this was done, I wanted to go back to my ADMIN Role.... but it just wouldn't go back to my normal view.

Section Access;

LOAD ACCESS,

Upper(NTNAME) as NTNAME,

Text(SECTION_ACCESS_FIELD) as SECTION_ACCESS_FIELD;

LOAD * INLINE [

    ACCESS, NTNAME, SECTION_ACCESS_FIELD

    ADMIN, domain\talwar, *

    ADMIN, domain\qlikview, *

];

Section Application;

I have tried to remove section access completely and then bring it back. I have also, tried to remove 'Initial Data Reduction Based on Section Access' and 'Strict Exclusion'. Nothing seem to have worked.

Any ideas why am I seeing this behavior? Is this a bug or by design?

Thanks,

Sunny

11 Replies
sunny_talwar
Author

Thanks everyone, all your suggestions worked. The final issue was related to me not listing all possible values for at least one user.

sunny_talwar
Author

Awesome explanation.... thanks mbaeyens‌ for further expanding on this.