8 Replies Latest reply: May 29, 2018 11:26 AM by Kevin Case RSS

    Disable export to excel - Qlik Sense

    Abhay Sudhakaran

      How do we disable the export to excel functionality on Qlik Sense Apps, what the different way to do it.

      At various level -  Sheet, APP and Server

        • Re: Disable export to excel - Qlik Sense
          Kevin Case

          Sudhakaran,

           

          By default, there is a rule that allows everyone except anonymous users to export from Apps.  If they have access to the App, they can export. You would need to disable this rule and build custom rules specifically for sheets an/or apps.

           

          If you build rules at the sheet level, just remember that you be constantly changing this rule as new sheets are added.

          Hope this helps.

           

          Kevin

          • Re: Disable export to excel - Qlik Sense
            Kevin Case

            SM,

             

            Yes it is possible.  YOU need to create the rule.

             

            The example I supplied is the default rule.  You would want to disable this rule and create your own.  For example, you could create a new rile called ExportAppDataCustom

             

            The Basic section would have Export Data checkbox checked.

             

            The Advanced section is where you build your rule.  The Resource Filter would still be App_* but the conditions is where you build YOUR custom rule.  I would build on what is there but you will need to add an AND clause specifying the name of the application and another AND to limit the user group.

             

            Something like and (resource.name='Sales App') and (User.Group='Sales Group')

             

            It's easer to control by group vs. individual users.

             

            I can not build the specific rule for you, only you can do that.  You should be able to find plenty of help in the online help (help.qlik.com).

            • Re: Disable export to excel - Qlik Sense
              Radim Balaz

              ExportAppData Disable, Create New Security Rules.

              In this case, it exported from all apps except the Test Export app.

               

              Export.jpg

                • Re: Disable export to excel - Qlik Sense
                  Kevin Case

                  Radim,

                   

                  That is correct.  Your rule states:  If the app name is not equal to Test Export then you have access to export.  That's why all other apps can export.

                   

                  You need to change your != to =.  This will make it: If the app name is equal to Test Export then you can export, otherwise all other apps will be denied access to export.

                   

                  Rules are for who you want to have access, not who you want to deny.  By default everyone is denied.

                   

                  The rule needs to evaluate to true in order to be allowed.

                   

                  Hope this helps.

                • Re: Disable export to excel - Qlik Sense
                  Kevin Case

                  Poppy,

                   

                  Assuming that your users are loaded from Active Directory, you should have access to the AD groups.  For example, If you wanted to allow all groups EXCEPT Accounting, you could try the following.

                   

                  Export.png