topic Re: Section access Sheet level security in QlikView

Section access Sheet level security

madhubabu — Tue, 15 Sep 2015 01:30:39 GMT

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

Re: Section access Sheet level security

qlikviewwizard — Tue, 15 Sep 2015 01:48:56 GMT

Hi Madhu,

Check these threads.

Sheet Level Access

Chart Level Access

Re: Section access Sheet level security

qlikviewwizard — Tue, 15 Sep 2015 01:50:14 GMT

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

Section Access

Re: Section access Sheet level security

salto — Tue, 15 Sep 2015 05:00:16 GMT

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.

Re: Section access Sheet level security

prajapatiamar38 — Tue, 15 Sep 2015 05:04:37 GMT

Hi PFA

Re: Section access Sheet level security

senpradip007 — Tue, 15 Sep 2015 05:09:19 GMT

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

Re: Section access Sheet level security

qlikviewwizard — Wed, 16 Sep 2015 01:23:00 GMT

Hi Madhu,

Did you able to resolve the issue?