Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Export charts to excel

Hi,

Can charts in QlikSense be exported to excel?

Thanks,

Bryan

9 Replies
gautik92
Valued Contributor III

Re: Export charts to excel

you cannot use macros in qliksense i hope

have a look at this link for extension

i hope it mwill help you

http://branch.qlik.com/projects/forumdisplay.php?22-Object-Extensions&_ga=1.212950675.645630541.1441...

ecolomer
Honored Contributor II

Re: Export charts to excel

See this examples:

gautik92
Valued Contributor III

Re: Export charts to excel

Hi ecolomer

We cannot use macros in qliksense right?

ecolomer
Honored Contributor II

Re: Export charts to excel

I'm sorry.

You are in QlikSense.

ogster1974
Honored Contributor II

Re: Export charts to excel

Hi Bryan you certainly can.  Right click on your chart object and you will get the following options.

Export data will do the trick.

Regards

Andy

Employee
Employee

Re: Export charts to excel

‌yes but not from a pivot chart . We are working to have that soon.

Not applicable

Re: Export charts to excel

We would like that feature also.  We actually did a balance sheet and the higher ups want it sometimes in excel.

When I do the export to PDF (was trying that) it only exported what was physically on the screen.  How do we make it do all the data?

We are talking about doing this in QlikSense, right?

Employee
Employee

Re: Export charts to excel

The export to excel will dump the data values (the aggregated values) used in the visual chart or tabular chart into an excel / tabular format. This is valid for almost all objects except the pivot table currently.

The underlying data (details) that roll into these aggregated values would need to be exported from a table object that has the necessary detailed fields in there. Is that what you want ?

Not applicable

Re: Export charts to excel

I checked with the developer and it is a pivot. I can’t be sure that we would always want all the underlying data or just the aggregated values.

We are new to all QlikSense so not sure at this point.

Cathy Swanberg

System Analyst

PH: 253.375.0707

FX: 253.375.0807

www.NorthwestDoor.com<http://www.NorthwestDoor.com>

Community Browser