topic Re: How to export table with current selection to excel? in App Development

How to export table with current selection to excel?

Thu, 15 Oct 2015 11:51:35 GMT

Hi, I would like to export table from Qlik Sense to excel including current selection in excel file, because I have to track source of exported data. So I need something like this:

Filter

Year: 2014, 2015

Country: USA, Canada, Mexico

Data

< exported table from qlik sense >

I know that in QlikView there is possibility to edit macro for creating excel file but I don't know how to do it in Qlik Sense. Any ideas? Thank you. !

Re: How to export table with current selection to excel?

saravanaprabhu — Mon, 19 Oct 2015 10:09:54 GMT

Please check this post

Export Qlik Sense report to excel

Re: How to export table with current selection to excel?

Thu, 22 Oct 2015 12:43:58 GMT

Hi, thank you for your answer but it not solve my problem. I know how to export data to excel, but I need to export also filtered parameters to the same file.

Re: How to export table with current selection to excel?

Thu, 17 Dec 2015 13:32:39 GMT

Hi,

I don't know how it works in Qlik sense but in QlikView go to user preferences and in export tab, check option On BIFF Export in your server

Re: How to export table with current selection to excel?

reddy-s — Thu, 17 Dec 2015 13:54:13 GMT

Hi Gnut,

You can export data from most of the visualizations by just right clicking and you happen to see an option Export to EXCEL.

The only Limitation is you cannot export a pivot table from QlikSense and this functionality is being added soon.

Re: How to export table with current selection to excel?

Mon, 21 Dec 2015 11:51:48 GMT

Hi Sangram, thank you for your answer. I know how to export data to excel, but I need to export also filtered parameters to the same file. I know, that it is possible in Qlik View, but probably not in Qlik Sense. The output of the exported table should contain for example filtered parameters on the first line (selected year and country) and exported table below. The reason I need it is, that when I look on exported data next month, I can't remember what I selected before I export data. This is easy example so I can write it down manually, but for more complex data it is time consuming to write it manually every time I want to export something. I hope that somebody is able to write extension to solve it. I wil try to create it also but I'm not excellent Qlik Extensions developer.

How to export table with current selection to excel?

Re: How to export table with current selection to excel?

reddy-s — Mon, 21 Dec 2015 15:35:29 GMT

Hi Grunt,

Your requirement completely makes sense. So in his case, an extension is the way to go. I will consider that as a good feature for my custom visuals as well.

Regards,

Sangram Reddy.

Re: How to export table with current selection to excel?

ashishbp — Mon, 18 Sep 2017 09:09:21 GMT

Hi Gnut,

have u got any solution for this?

Re: How to export table with current selection to excel?

UrbanBadger — Mon, 04 Feb 2019 22:34:09 GMT

I have the same issue. The only thing I have found so far is the "GetFieldSelections" function, which you can add for each selection filter box, then string them together with comma separation in a text object. Not ideal, but it can be exported.

='Data1: '& GetFieldSelections(Filter1)& ' , Data2: ' & GetFieldSelections(Filter2)

Re: How to export table with current selection to excel?

shlomoh — Sun, 26 Sep 2021 13:43:32 GMT

You can do this and much more, using LogiExport extension for QlikSense
https://logiexport.logsys.co.il/documentation