Disable export excel option on table object

[#1]

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

[#2]

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

[#3]

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

[Anonymous]

Hi Pranav

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

[Anonymous]

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.

[girish2195]

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

[girish2195]

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