Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor III

Sheet level access to specific stream only

HI all,

I have looked at this video, Qlik Sense Stream Management  Security Rules and Exception Management - YouTube and at this page Sheet or App Object Level Security Qlik Sense‌ but I am unable to get what I want,

What I am trying to do is ; example

I have 2 users, that have access to 5 streams with its apps and sheets, but there is 1 stream (Sales which has 1 app and 5 sheets) that I want User 1 to have access to 3 sheets and  User 2 to have access to 3 other sheets

sheet names;

1 Sales summary

2 CS

3 Budget

4 Service

5 CustomReport

User 1 has access to sheets (1,2,3) user 2 has access to (1,4,5)

I have tried following the links above but I don't get it right it either removes access from both users/ and their other streams or it give access to all.

I don't want the other streams to be affected.

the security I am using is

(resource.resourcetype = "App" and resource.stream.HasPrivilege("read")) or ((resource.resourcetype = "App.Object" and resource.published ="true" and resource.objectType != "app_appscript" and resource.objectType != "loadmodel") and resource.app.stream.HasPrivilege("read")

and ((resource.name!="Budget" or resource.name!="CS") or user.name="User 2")

and ((resource.name!="Service" or resource.name!="CustomReport") or user.name="User 1")


Would you please be able to help

Many thanks,

Community Browser