Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
aheavy95
Creator
Creator

Section Access example with wildcard

Hi all 

in a project im working on, there is a section access which gives each manager access to his store.

Some admins have access to all stores with the * value

My question is how do I implement - giving no access to any store for each user who is not on that list

 

thanks in advance

Labels (3)
2 Replies
Mark_Little
Luminary
Luminary

Hi,

Can you share some more details on how you are applying the Section Access, as i would expect this to being the case if applied correctly. 

simsa
Contributor III
Contributor III

I generally maintain an excel file for section access:

Section Access;

LOAD
Distinct
USERID,
ACCESS,
STORE
FROM [lib://path/abc.xlsx]
(ooxml, embedded labels, table is sheet1);

Section Application;

Alternately, you can use inline statement as well:

Section Access;
LOAD * INLINE [
ACCESS, USERID,STORE
ADMIN,NANET\ABCDEG,*
USER,NANET\ABCTHS,StoreA
];
Section Application;

Here ACCESS column has data such as ADMIN, USER

STORE column contains the store in which you want to give access: StoreA, StoreB or * (Store column is optional)

Userid not in the section access list won't be able to access the dashboard.

 

Hope this helps!
Simran