Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Export charts to excel

Hi,

Can charts in QlikSense be exported to excel?

Thanks,

Bryan

9 Replies
gautik92
Specialist III
Specialist III

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
Master II
Master II

See this examples:

gautik92
Specialist III
Specialist III

Hi ecolomer

We cannot use macros in qliksense right?

ecolomer
Master II
Master II

I'm sorry.

You are in QlikSense.

ogster1974
Partner - Master II
Partner - Master II

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
Former Employee
Former Employee

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

Not applicable
Author

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
Former Employee
Former Employee

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
Author

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>