Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
taylorjl
Contributor II
Contributor II

limit export to excel by user

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!

12 Replies
alexandros17
Partner
Partner

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
Partner
Partner

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

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
Partner
Partner

Vikas Mahajan Answer is perfect

mov
Champion III
Champion III

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

taylorjl
Contributor II
Contributor II
Author

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
Creator II
Creator II

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.

mov
Champion III
Champion III

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