Re: Export charts to excel - Qlik Community

Report Inappropriate Content · ‎2015-09-24

Hi,

Can charts in QlikSense be exported to excel?

Thanks,

Bryan

gautik92 · ‎2015-09-24

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 · ‎2015-09-24

See this examples:

gautik92 · ‎2015-09-24

Hi ecolomer

We cannot use macros in qliksense right?

ecolomer · ‎2015-09-24

I'm sorry.

You are in QlikSense.

ogster1974 · ‎2015-09-24

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

JonnyPoole · ‎2015-09-24

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

Report Inappropriate Content · ‎2015-11-20

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?

JonnyPoole · ‎2015-11-20

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 ?

Report Inappropriate Content · ‎2015-11-20

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>