topic Re: How to control access right for send to excel. in QlikView

How to control access right for send to excel.

alex_stone — Wed, 02 Dec 2015 10:14:09 GMT

Currently, we have a requirement as below.

We need to control that some one can use send to excel function, some one cannot use this function based on different domain user.

How to reach this requirement? Thanks.

Re: How to control access right for send to excel.

Siva_Sankar — Thu, 03 Dec 2015 02:55:29 GMT

Alex,

There is no such feature in qlikview yet to do that.

But, you can create a button with a macro to export to excel and show for some users or hide for some users by using the OSUser() function. In this way the
button will be visible for some user and invisble for the rest.
You can create the macro to export to excel and set as action in this button.

Example macro below: not sure whether it will work in Ajax or not.

Sub exportToExcel()
Set obj = ActiveDocument.GetSheetObject("TB01")
obj.ExportBiff "C:\Test.xlsx"
Set obj = nothing
End Sub

Regards,
Siva sankar

Re: How to control access right for send to excel.

marcus_sommer — Thu, 03 Dec 2015 08:36:22 GMT

Within the qmc by Documents --> User Documents is an option available to personalize the excel export + print:

- Marcus

Re: How to control access right for send to excel.

Anonymous — Thu, 03 Dec 2015 08:43:05 GMT

As a follow up to Marcus approach, if the app is not large, you could even distribute two identical versions of the app:

1. For user Group A - allow export.

2. For user Group B - disallow export.

This sounds like it could resolve your use case without much customization efforts.

Re: How to control access right for send to excel.

alex_stone — Mon, 01 Feb 2016 15:24:45 GMT

Yes, we use above approach to reach the requirement. Thank you for your attention.