5 Replies Latest reply: May 24, 2017 5:00 AM by Michele De Nardi RSS

    How to Hide sheets in Qliksense QMC?

    rajesh lingutla

      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

        • Re: How to Hide sheets in Qliksense QMC?
          Michele De Nardi

          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.

            • Re: How to Hide sheets in Qliksense QMC?
              rajesh lingutla

              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

                • Re: How to Hide sheets in Qliksense QMC?
                  Michele De Nardi

                  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"

                            )

                       )

              • Re: How to Hide sheets in Qliksense QMC?
                beck bakytbek

                Hi Rajesh,

                 

                look at this:

                 

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

                 

                I hope that helps

                 

                Beck

                • Re: How to Hide sheets in Qliksense QMC?
                  Rohit Kumar

                  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.