Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have application like Empdata.qvf and it contains sheets like sheet1,sheet2,sheet3,sheet4.
I want hide sheet1 and sheet3 in qliksense QMC.
Could you please let me know how can i do it in QMC and please share me the code for security rule with defining for sheet1 and sheet3.
Explain me in detail,it helps a lot for me.
Thanks in Advance,
Rajesh
You can change "Stream" security Rules like this:
(
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!="sheet1" or
resource.name!="sheet2" or
resource.name!="sheet3" or
resource.name!="sheet4"
)
)
Doing this you can "hide" sheet1, sheet2, sheet3 and sheet4 to non-RootAdmin Users.
Thanks a lot Michele..i am not able to understood where i need to go and change in QMC exactly and also i need to do it for only selected application,can i mention application name in above code???
Thanks,
Rajesh
Hi,
you have to go into QMC (http(s)://YourQlikSenseServer/qmc, you must be qliksense admin) and than Click on "Security Rules" in the context menù, than find the correct security rules and apply my change.
Yes, you can also hide sheet1, sheet2, sheet3 of specific app by add "resource.app.name" property.
Your final security rule could be something like:
(
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.app.name="Empdata" and
(
resource.name!="sheet1" or
resource.name!="sheet2" or
resource.name!="sheet3" or
resource.name!="sheet4"
)
)
Hi Rajesh,
This document will guide you to do sheet level restriction in Qlik Sense
Sheet or App Object Level Security Qlik Sense
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.