topic Re: Export To Excel in QlikView

Export To Excel

Anonymous — Fri, 21 Nov 2014 10:07:20 GMT

Hi,

Hopefully an easy answer to this one... am I correct in thinking in the latest version of QlikView / server setup it is still not possible to pick and choose which objects allow / block export to excel, which includes the right-click option to export on charts and tables.

E.g. all export including right-click is locked down, except for a specific table / chart.

Thanks,

Re: Export To Excel

amit_saini — Fri, 21 Nov 2014 10:14:18 GMT

Richard,

Open your QVW-> got to Settings-->Document Properties and checked accordingly.

Thanks,

Re: Export To Excel

vardhancse — Fri, 21 Nov 2014 10:17:58 GMT

In charts->Properties->Caption<tab>->Special Icons we can enable export to excel

Re: Export To Excel

Anonymous — Fri, 21 Nov 2014 10:20:40 GMT

Thanks Amit but that allows export to all objects, I'm trying to lock it down and only allow it for a specific object.

Re: Export To Excel

Anonymous — Fri, 21 Nov 2014 10:22:45 GMT

Thanks Sasi, but that option only controls the icons not the right-click options.

Re: Export To Excel

vardhancse — Fri, 21 Nov 2014 10:28:39 GMT

in document settings->security<tab> un check 'Allow Export'.

So that for every object->right click->export to excel will be disabled.

For which ever charts we want to export go to chart properties->Caption<tab>->Special Icons we can enable export to excel.

So that only to those charts we enabled export to excel we can see the option in chart header and by default right click->export to excel will be disabled.

Re: Export To Excel

Anonymous — Fri, 21 Nov 2014 10:36:03 GMT

Thanks again Sasi, that would be exactly what I need but when I un-check 'Allow Export' no export icon appears on table / chart captions when the special icon options are ticked. Maybe that's a function of a newer version? I have QV 11 and 11.20.11718.0

Re: Export To Excel

Anonymous — Mon, 24 Nov 2014 09:24:54 GMT

Solution found :

1. Lock the entire app by un-check 'Allow Export' - this stops the caption icons and right-click.

2. Create a button and macro to export specific objects to Excel.

3. You can show / hide the button/s based on data or user.

Thanks all,