topic Re: Export Excel in QlikView

Export Excel

brijesh1991 — Fri, 19 Jul 2013 07:57:12 GMT

Hi All,

I have 3000 users. I wanted to give export to excel and print functionality to 2995 users, but rest 5 should not be able to catch this funtionality.

How can I disable right click for this 5 users?

Best Regards,

Brijesh

Sat, 20 Jul 2013 13:50:13 GMT

From QMC

paulyeo11 — Sun, 21 Jul 2013 07:24:00 GMT

I think access control should do the job , but i not sure how to achieve this .

marcus_sommer — Mon, 22 Jul 2013 09:44:39 GMT

You could try it with macros which will triggered by OnChangeVariable:

var = if(match(OsUser(), 'a', 'b',...), 0, 1)

See in APIGide.qvw for examples like this:

temp=ActiveDocument.GetProperties

temp.UserPermissions.AllowPrintAnyway = false

ActiveDocument.SetProperties temp

temp=ActiveDocument.GetProperties.UserPermissions.AllowExport

if temp then msgbox("Export allowed")

- Marcus