topic Re: Disable export to excel - Qlik Sense in Visualization and Usability

Disable export to excel - Qlik Sense

Anonymous — Wed, 01 Jun 2016 18:56:53 GMT

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

kevincase — Wed, 01 Jun 2016 20:39:51 GMT

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

Anonymous — Fri, 03 Jun 2016 18:39:22 GMT

Thanks,

Is it possible to disable / enable the rule for a specific resource object such as a specific app or stream ?

My objective is:

1. To allow export for all apps except 1 specific app example (sales app)

2. Allow only a set of specific users to export on sales app.

Re: Disable export to excel - Qlik Sense

kevincase — Fri, 03 Jun 2016 20:44:39 GMT

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

Anonymous — Mon, 06 Jun 2016 21:54:10 GMT

Thanks Kevin,

I am trying to build something like this:

I am trying to create a rule that allows export for all apps which are not part of a specific stream. But this doesnt work for me. Any help appreciated here

Re: Disable export to excel - Qlik Sense

radimzv76 — Mon, 21 May 2018 19:35:13 GMT

ExportAppData Disable, Create New Security Rules.

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

Re: Disable export to excel - Qlik Sense

kevincase — Mon, 21 May 2018 20:33:55 GMT

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

poppypearce — Thu, 24 May 2018 06:49:40 GMT

Hi,

Any Idea how to disable Export Option for one group of users? Regardless of the Apps?

Regards,

Poppy

Re: Disable export to excel - Qlik Sense

kevincase — Tue, 29 May 2018 15:26:42 GMT

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.

Re: Disable export to excel - Qlik Sense

acardella — Thu, 27 Dec 2018 14:38:21 GMT

Hi All...

is it possible to control and disable ONLY "export to excel" ? but hold "export to PDF"?

thanks

Agostino

Re: Disable export to excel - Qlik Sense

rpapa — Wed, 04 Dec 2019 14:49:46 GMT

Is it possible to disable such exporting functionality when opening the apps from a mobile device? Otherwise, allow exporting as usual.

Re: Disable export to excel - Qlik Sense

jankolar33 — Thu, 24 Sep 2020 11:27:01 GMT

Hello Qlik Community,

in our system we have set up Stream Access by AD groups membership (where a Custom Property is assigned to a stream). What we need to achieve is : disable export option for one stream (StreamA). In the stream there are apps APP1, APP2 and APP3. We need to keep enabled the export option for APP1, but only for part of the user audience (defined by a special AD group). For the APP2 and APP3 the option should remain disabled. For the rest of the streams (apart of StramA) the xport Option should remain enabled should remain enabled. Is there any way to achieve this? many thanks, regards, Jan