limit export to excel by user

[Anonymous]

Hi - Is it possible to prevent a certain USER from exporting/downloading to excel from a document? They should still be allowed the option to print. 

Any ideas would be great, thanks!

[alexandros17]

you should have to control icons on objects and I think you can't (perhaps with a macro)

a simplest way to do what you want is create two copies for each object and condition the visualization of the object to the user.

Hope it helps

[jpapador]

In the management console go to the documents tab and click availability (I believe it is a subtab under the server tab).  There is an option to assign users or groups the ability to export to excel.

[vikasmahajan · Accepted solution]

you can do that in QlikView Management Console. Go to tab "Documents" and choose you documents, in your right go to tab "Server" and choose to section "Availability" and unthick "Print and Export to Excel, you can also choose for which user group in here.

Vikas

[alexandros17]

Vikas Mahajan Answer is perfect

[Anonymous]

Unfortunately it doesn't allow separate permissions for "export" and "print".  Area of improvement for QlikTech...

[vikasmahajan]

Yaa , We want Print Option but not excel.. is there any update by Qliktech ?

vikas

[Anonymous]

thank you for all of the comments.  I'm new to this but would I be able to remove the option in the document properties to export but to still allow to print.  This would obviously affect all users, but how about a button that only shows on a condition and that would be the user, not sure if that can be done or not or even how to?

[mikkeltaylor]

Hi Lynn,

I asked this of our trainer last week, as we would want our users to be able to print, but not export to excel.

Whilst we didn't properly test it he did suggest something along the lines of:

- Changing the document properties to allow/exclude printing/send to excel

- Using section access to allow ADMIN to be able to still do everything

I've got to catch up with our training so I'll try to get him to document exactly what he suggested, as it did look like it would work.

Michael.

[Anonymous]

Lynn,

To show objects for some users, you can use function OSUser() to identify current user.  It returns result in a form DOMAIN\USER.  So, if you want to allow a button (or any sheet object o sheet) to be visible to some users, you can use "show condition" like this:

wildmatch(OSUser(), '*USER1','*USER2','*USER3')

I am not sure how you can use it to resolve "print but don't export" problem.

Michael,

The trainer apparently meant to uncheck "allow export" in the document security, check "allow print (when export is prohibited)", and check "admin override security".  Yes, you need section access to define who the "admin" is.
I tried this once, and it didn't work.  Don't remember the details, it was long ago.  But it was a very different QV at that time, it maybe working now.

Regards,
Michael