Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
rajeshlingutla1
Contributor

How to Hide sheets in Qliksense QMC?

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

5 Replies
micheledenardi
Valued Contributor

Re: How to Hide sheets in Qliksense QMC?

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
Honored Contributor

Re: How to Hide sheets in Qliksense QMC?

Hi Rajesh,

look at this:

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

I hope that helps

Beck

rajeshlingutla1
Contributor

Re: How to Hide sheets in Qliksense QMC?

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
Valued Contributor

Re: How to Hide sheets in Qliksense QMC?

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
Valued Contributor II

Re: How to Hide sheets in Qliksense QMC?

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.