topic Re: excel export in QlikView

excel export

Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

Is it possible to get the view of a qlikview pivot table in excel?

My client is asking for it.

i want to do this without using macros.

Please help.

Re: excel export

trdandamudi — Tue, 12 Apr 2016 13:07:15 GMT

Right click on the Pivot chart and select "Copy To Clipboard" and select "Full Table". Now go to Excel and paste it. You will get the same view as Qlikview, Hope this helps....

Re: excel export

Tue, 12 Apr 2016 13:27:01 GMT

Hi thirumala,

i want to do this when client export a chart to excel.

The way you suggested will work only on developer application.

Re: excel export

jonathandienst — Tue, 12 Apr 2016 13:32:57 GMT

No - that can be done by users as well. Or use the Export to Excel option from the caption bar or a right click.

Re: excel export

trdandamudi — Tue, 12 Apr 2016 13:39:05 GMT

All users can use this option....

Re: excel export

Anonymous — Tue, 12 Apr 2016 13:53:36 GMT

Yup.

As long as the User Document has the Print and Export to Excel option is selected for All Users in QMC.

Re: excel export

settu_periasamy — Tue, 12 Apr 2016 14:05:19 GMT

I don't think it is possible without macro (except Copy to Clipboard -> Full Table)

send to excel formatting in Pivot table‌

if you consider to use macro, refer this thread..

Same Formating of qlikview pivot table in Excel

Re: excel export

Tue, 12 Apr 2016 14:48:42 GMT

i cant see this option when i view the report on Access point.

Please suggest how to do this on Accesspoint

Re: excel export

settu_periasamy — Tue, 12 Apr 2016 14:51:16 GMT

If it is AJAX mode, i think we can't see the Copy to Clipboard option.

Re: excel export

Anonymous — Tue, 12 Apr 2016 14:59:48 GMT

Use the right click Send to Excel.

I use it regularly via AccessPoint in Ajax mode.

Re: excel export

trdandamudi — Tue, 12 Apr 2016 15:01:54 GMT

When you make the right click on the chart are you not getting the option ?

Re: excel export

settu_periasamy — Tue, 12 Apr 2016 15:04:31 GMT

Yes, I know that. But the OP needs to do the Pivot table view in excel also.

I don't see the option Copy to Clipboard option in Ajax Mode.

Re: excel export

Tue, 12 Apr 2016 15:37:56 GMT

No, i only have these options.

Re: excel export

jonathandienst — Thu, 14 Apr 2016 08:31:59 GMT

So, just click the Send to Excel option...

Re: excel export

Chanty4u — Thu, 14 Apr 2016 08:34:09 GMT

just select send to excel

it means ur exporting only.