topic Re: Qlik Sense Export Selections to Excel in Integration, Extension & APIs

Qlik Sense Export Selections to Excel

andyhudson — Sat, 16 Nov 2024 00:52:16 GMT

Hi, we would like to include the current selections in the exported Excel document. I believe that this feature is not currently supported by Qlik and that this has been added as a suggetion: https://community.qlik.com/t5/Ideas/Current-Selection-while-export-data/idi-p/1560174#comments

Is this still the case? Is there a workaround? I have tried modifying our export function, in our mashup extension, but unable to add the selections to the generated Excel document.

We're currently using Qlik Sense Enterprise April 2019.

Re: Qlik Sense Export Selections to Excel

GaryGiles — Tue, 05 Jan 2021 19:20:42 GMT

If you are exporting a table object, one work around that I have used is to add an additional column at the end of the table with an expression of =' '. Then for the label, use =GetCurrentSelections(). Not a great solution, but at least the user can find what selections were in effect when they exported the data. Of course, it only works for a table.

Re: Qlik Sense Export Selections to Excel

andyhudson — Wed, 06 Jan 2021 11:09:27 GMT

Thanks for sharing this. It's not a bad idea concerning the tables. As you mentioned this solution would not work when exporting data from other formats such as from charts which unfortunately we require a solution as well.

I was thinking of maybe manipulating the table object in order to inject the selections prior to exporting (table.exportData(...)) but as far as I can see I would need to recreate the dimensions and measures based on the original values of the viz to be exported, but I can't find a way to do this.

Re: Qlik Sense Export Selections to Excel

Gui_Approbato — Wed, 06 Jan 2021 11:58:31 GMT

Hello Andy,

Some weeks ago I came across this extension (called Smart Export) which might be useful for what you need.

You can export tables and also include the selections automatically (and much more).

Check it out:

https://developer.qlik.com/garden/5835ddec37ff01d0caed2401

Re: Qlik Sense Export Selections to Excel

andyhudson — Wed, 06 Jan 2021 13:28:49 GMT

Thanks very much for this info. It looks promising. I'll check it out further.