topic Re: limit export to excel by user in QlikView

limit export to excel by user

Anonymous — Wed, 22 Jan 2014 14:30:57 GMT

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!

Re: limit export to excel by user

alexandros17 — Wed, 22 Jan 2014 14:46:08 GMT

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

Re: limit export to excel by user

jpapador — Wed, 22 Jan 2014 14:50:12 GMT

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.

Re: limit export to excel by user

vikasmahajan — Wed, 22 Jan 2014 14:50:21 GMT

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

Re: limit export to excel by user

alexandros17 — Wed, 22 Jan 2014 14:59:17 GMT

Vikas Mahajan Answer is perfect

Re: limit export to excel by user

Anonymous — Wed, 22 Jan 2014 15:07:49 GMT

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

Re: limit export to excel by user

vikasmahajan — Wed, 22 Jan 2014 15:17:07 GMT

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

vikas

Re: limit export to excel by user

Anonymous — Wed, 22 Jan 2014 15:24:33 GMT

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?

Re: limit export to excel by user

mikkeltaylor — Wed, 22 Jan 2014 15:33:23 GMT

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.

Re: limit export to excel by user

Anonymous — Wed, 22 Jan 2014 15:45:43 GMT

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

Re: limit export to excel by user

Anonymous — Fri, 24 Jan 2014 16:34:16 GMT

Thanks Michael. With regard to the show button, I was going to remove export and print for that user on the doc, then for him/her only create a button to print visible for that user, but I see that wouldn't work as I've removed the ability to do it at a higher level.

thanks for your time, much appreciated.

Re: limit export to excel by user

mikkeltaylor — Mon, 27 Jan 2014 09:32:47 GMT

Hi Lynn,

This is what I received back from the trainer:

Printing for all – Send to Excel for some:

This was the procedure as I remember it:

Section Access on the document
Normal users defined as USER in Section Access
Users with Send-to-Excel rights defined as ADMIN in Section Access
Setup Security in Document Properties on the document like this:

Re: limit export to excel by user

Thu, 08 Oct 2015 20:48:08 GMT

QlikView Management Console > Task Properties > Server > Availability > User Privileges: Print Export To Excel | Named Users (select users).

Use Windows user accounts for large groups in the distribution list. An individual user can not override a group. However, if you add the individual user to the distribution list and the export exception list it will then override the group.