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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
HAmzehAF
Partner - Creator
Partner - Creator

section access

Hello, 

i want to do 2 section access on one app like one section access for store mangers and another section access for store emp 

 

store manger can see the whole store but the emp can see sections 

how can i do this, 
i have a excel for store num and section num 

5 Replies
Or
MVP
MVP

Typically this would look something like:

Section Access;

Star is *;

Load * INLINE [

USERID,  STORE, STORESECTION

Manager1, Store1, *

Manager2, Store2, *

Employee1, Store1, Section1

Employee2, Store1, Section2

Employee3, Store2, Section1

];

HAmzehAF
Partner - Creator
Partner - Creator
Author

thank you, 

 

i want the emp to get only the Section2
Employee2,  Section2
dont include the store with it how to do that? 

 

cuz for me its not like this its for store manger and commercial mangers so everyone of them can see somthing 
store manger can see his store and commercial can see all store but only his dep 

Or
MVP
MVP

You can use * for the store if you don't want the store to be filtered, but this seems confusing - if section2 is unique to a single store then it won't make a difference, and if it isn't unique then the employee will see that section across stores, which I don't think is what you wanted?

HAmzehAF
Partner - Creator
Partner - Creator
Author

hello,

forget the emp example help me with this ,

i have  store manger and commercial mangers so everyone of them can see somthing ,

store manger can see his store that i have num in excel and commercial can see all store but only his department and i have the department num in excel too


Or
MVP
MVP

This seems to already be covered by the simple case of two fields in the section access that I detailed above, assuming department numbers are unique. If department numbers repeat across stores, you will need to include the store number in the employee lines to prevent employees from seeing the same department across all stores.  * simply means "All values for this field".