Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
elliotrheya
Not applicable

Export all Objects in a report to Excel

Hi,

how do you export all the objects in a report to excel?

Currently only the items in grid/chart is being exported. All the page filters are being ignored

9 Replies
Khan_Mohammed
Not applicable

Re: Export all Objects in a report to Excel

When you export whole sheet, filters are not exported.

If you want to export filters before/after selection, you'd have to do it individually.

Right click on any filter>Export Data

elliotrheya
Not applicable

Re: Export all Objects in a report to Excel

lol.

you're funny brah!!!

Lech_Miszkiewicz
Not applicable

Re: Export all Objects in a report to Excel

he is right - when exporting to XLS you are exporting single object like chart, listbox, tablebox, multibox etc. Ultimetly you can use print sheet to print everything (like screenshot) or use NPrinting to build template to carry accross all objects from sheet to excel.

However Aehman is right. you have to do it one by one - so i guess i am funny too .

cheers

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
elliotrheya
Not applicable

Re: Export all Objects in a report to Excel

Hi.. thanks for the 'NPrinting' suggestion.

But it is sad Sense does not have the option to select all objects like in QlikView when you use the 'On BIFF Export' option

Lech_Miszkiewicz
Not applicable

Re: Export all Objects in a report to Excel

ohh, You have actually made me relize i was thinking QlikView world. In QlikSense it would be probably better just ot build text object with formula showing all selected values.

I am not 100% sure but i was strugling exporting selections in QlikSense at all. i do not think it is curently possible from filter pane and you have to use table object to do that.

regards

lech

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
elliotrheya
Not applicable

Re: Export all Objects in a report to Excel

coo,

I tried to use getcurrentselections() in the footnote, title.

But it turns out Sense does not export Titles. Footnotes to excel either...

Khan_Mohammed
Not applicable

Re: Export all Objects in a report to Excel

Qlik Branch

Use the above extension to export your Current Selection to XL file.

You can add dimension/measures to this extension as an export option...

I however used GetCurrentSelections('|','=') to get only Current Selections.

Thanks.

Lech_Miszkiewicz
Not applicable

Re: Export all Objects in a report to Excel

It is all great about extensions as long as you do it on your own "battlefield".

If you provide serice to other companies and build Qlik solutions - than extensions become unsupported part of it which is not really good .

I would really suggest to stick to vanila options to make sure they work in future

regards

Lech

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
elliotrheya
Not applicable

Re: Export all Objects in a report to Excel

Totally agree with you...