How to Hide sheets in Qliksense QMC?

[Anonymous]

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

[micheledenardi]

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.

[beck_bakytbek]

Hi Rajesh,

look at this:

Tips and tricks for section access in Qlik Sense (2.0+)

I hope that helps

Beck

[Anonymous]

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

[micheledenardi]

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"

          )

     )

[rohitk1609]

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.