topic Re: Disable export excel option on table object in QlikView

Disable export excel option on table object

Thu, 03 Mar 2011 17:48:48 GMT

Hi,

I would like to disable the 'export to excel' option (both icon and right click) if the table object has more than 50,000 records. This is because when the table object has more records and user clicks on 'export to excel' option, the system is taking long time to send the data to excel.

Can I write a macro or something to disable this button when the thable object has more than 50,000 records? When user make use of list boxes to reduce the table object records to <50,000 the export to excel option should be available to users.

Any help?

Regards,

Murali

Disable export excel option on table object

Mon, 02 Apr 2012 13:59:12 GMT

Hi Murali,

In the Qlikview Document Go to Settings-Document Properties- Security-Allow Export. Uncheck this option. It will deactivate the Export to excel for all the objects. if you want to deactivate the export to excel for a specific object then Right Click and go to caption and Uncheck the Send to Excel.

AND

Export restriction by user is available in QV11 server feature, available in all editions.

Hope this helps.

Regards,

Pranav

Disable export excel option on table object

Fri, 20 Apr 2012 13:03:31 GMT

Sorry,

The upper method will not work for ur requirement.

Try to write macro for export toexcel to be enable and disable and with section access provide the user authority who can see it or not.

Thanks,

Pranav

Re: Disable export excel option on table object

Anonymous — Tue, 11 Jul 2017 06:06:04 GMT

Hi Pranav

I want to perform the same task in qliksense
How can I achieve that ?

Re: Disable export excel option on table object

Anonymous — Tue, 11 Jul 2017 07:56:35 GMT

Hi ,

You can create a variable like "vLimit" and create a input box with this variable.

Then right click on the sheet object i.e straight table or listbox , go to Dimension Limits tab.

Then , you can export it to linited rows to excel.

This is just one of the way .

Hope it helps.

Thanks,

Krishnam Raju.

Re: Disable export excel option on table object

girish2195 — Tue, 11 Jul 2017 08:53:12 GMT

Hi Murali,

In qlikview u can disable it in caption tab of the chart properties.

Just go to caption tab under properties and uncheck send to excel.

Regards,

Girish Kumar DV

Re: Disable export excel option on table object

girish2195 — Tue, 11 Jul 2017 08:53:13 GMT

Hi Murali,

In qlikview u can disable it in caption tab of the chart properties.

Just go to caption tab under properties and uncheck send to excel.

Regards,

Girish Kumar DV