Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to disable export table data to excel ?

Hi All

i have a table in Qlik View table , which display the list of email address , May I know how to prevent user from Send the data to excel ? 

by default user can use the mouse right click and export data to excel . May I know how to disable this feature ? As the data are confidential. 

paul Yeo 

1 Solution

Accepted Solutions
rushikale0106
Contributor III
Contributor III

Hi,

I recently worked on the same query. 

And you can solve it using a security option for the sheets, which you can find in document properties.

Go to Settings -> Document Properties(CTRL+ALT+D) -> Security. Uncheck the Allow Export option to disable the export option. It will disable the Export option from right-click.

This setting is common for the whole document if you want to place it for certain users then you can go for Section access.

 -Regards,

Rushika

View solution in original post

4 Replies
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

I am not sure if that's possible for one object.

As for all Document objects to should refer to Settings > Document Settings > Security > uncheck Allow Export.

Besides, if that confidential information you should prevent it from seeing. You could work something out by checking Object Properties > Layout > Show option. Show the object only for users who have the privilege to see the emails.

rushikale0106
Contributor III
Contributor III

Hi,

I recently worked on the same query. 

And you can solve it using a security option for the sheets, which you can find in document properties.

Go to Settings -> Document Properties(CTRL+ALT+D) -> Security. Uncheck the Allow Export option to disable the export option. It will disable the Export option from right-click.

This setting is common for the whole document if you want to place it for certain users then you can go for Section access.

 -Regards,

Rushika

paulyeo11
Master
Master
Author

Dear Rush

I try your instruction , when i un-tick on " Allow Export " , and click on apply. when i try to go back the step and check , found " All Export " is tick again. Meaning i cannot un-tick it. I am using Ver 9 

paulyeo11_0-1594781288186.png

 

rushikale0106
Contributor III
Contributor III

Hello @paulyeo11 ,

I guess it might be the issue with the version. Since I can do these changes perfectly on Ver 12.

Or, might be some mistake while using it from your end.

Kindly try to do it again after restarting and let me know if it still doesn't work.