Qlik Sense Export Selections to Excel

[andyhudson]

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. 

[GaryGiles]

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.

[andyhudson]

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.

[Gui_Approbato]

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

[andyhudson]

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