Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
madhubabu
Contributor III
Contributor III

Section access Sheet level security

Hi all,

I have 100 users who are accessing the application(QVW).

user1 has to access sheet1,sheet2

User2 has to access sheet3,sheet4,sheet5

user3 has to access sheet6, sheet7, sheet8 same way it goes till 100 users

How can we achieve this any idea?

Thanks in advance,

Madhu

6 Replies
qlikviewwizard
Master II
Master II

Hi Madhu,

Check these threads.

Sheet Level Access

Chart Level Access

qlikviewwizard
Master II
Master II

This one as well. It is a thread about all security threads.

Section Access

salto
Specialist II
Specialist II

Hi Madhu,

     you need to set the permissions in the Sheet properties. Go to Sheet1 -> Properties -> General -> Show Sheet -> Check on "Conditional" and then fill in the condition like this:

     =mixmatch(osuser(),'domain\user1')

Do the same for Sheet2.

For Sheet3, Sheet4 and Sheet5:


     =mixmatch(osuser(),'domain\user2')

And so on.

Hope this helps.

prajapatiamar38
Creator II
Creator II

Hi PFA

senpradip007
Specialist III
Specialist III

Do you have any group of users who are using certain sheets or not?

qlikviewwizard
Master II
Master II

Hi Madhu,

Did you able to resolve the issue?