idea Re: Current Selection while export data in Suggest an Idea

Current Selection while export data

Riccardo — Wed, 25 Nov 2020 15:12:24 GMT

Like Qlik View, If I export data from App, I have to know what selection active are

Re: Current Selection while export data

vegard_bakke — Thu, 02 May 2019 08:47:39 GMT

I second this suggestion. It is crucial that the context is exported as well as the numbers.

In a mashup, we managed to solved this in a cumbersome way, by adding new columns for all the fields with a selection, in a duplicate of the chart's hypercube definition. It works when exporting to Excel, but is quite a bit of extra overhead that may or may not break at each upgrade.

Re: Current Selection while export data

John_Teichman — Tue, 04 Feb 2020 09:29:14 GMT

For reference, this request was included in another idea from 2018: https://community.qlik.com/t5/Qlik-Sense-Ideas/Show-applied-selections-in-Snapshot-library-and-data-export/idi-p/1499249. This idea will stay open, even though it is a duplicate.

Re: Current Selection while export data

95tribe — Thu, 09 Apr 2020 13:59:36 GMT

This is a very important requirement for our stakeholders. It was standard behavior in our QlikView apps. When we migrated to Qlik Sense this functionality was not available and is the biggest complaint from our users.

Re: Current Selection while export data - Status changed to: Open - Collecting Feedback

Caique_Zaniolo — Mon, 20 Apr 2020 15:54:51 GMT

Thank you all for your feedback on ways to improve our product. While this is something we understand would be important to provide more context to exported files, this is not in our short-term roadmap.
Please continue to show your support for this idea.

Re: Current Selection while export data

blipblopdk — Wed, 06 May 2020 03:50:17 GMT

I second that this suggestion and actually made the same suggestion, but it has been closed due to being a duplicate request. Here is my original request:

I would like to suggest that active filter selections are included when doing an "Export data" of a visualization (table, chart or other type) in Qlik Sense.

This will clearly help every user exporting data, as they will know what they have exported / are looking at in Excel.

In my opinion, this is such a basic feature, that I do not understand that it is not already included in Qlik Sense.

Re: Current Selection while export data

millerhm — Thu, 07 May 2020 15:22:43 GMT

+1 from me - this is a consistent requirement from our users as well. An export is not useful/reliable if it does not contain selections context.

Re: Current Selection while export data

pierreguss1 — Thu, 13 Aug 2020 16:03:30 GMT

I agree, it is very important for users

Please also add the extract date

Re: Current Selection while export data

as63 — Fri, 14 Aug 2020 10:55:54 GMT

For me this is not an option but a must-have. I don't understand why this feature has been removed (compared to QV).

Re: Current Selection while export data

Ame — Mon, 17 Aug 2020 14:50:17 GMT

@ Vegard_bakke

Can you explain how you did this in a mashup? I am using Qlik sense pivot table, I want to have the option to export data with current selections.

Re: Current Selection while export data

vegard_bakke — Tue, 25 Aug 2020 10:13:06 GMT

I don't know if the pivot table will influence this in a way. It might, at the dimensions are split on to axis.

I don't remember it all, but I'll try to explain:

We have a mashup were the 'export' button lives. This code takes the hypercube definition of the chart that should be exported. It also retrieved the selected filter dimensions.

Then it builds a new hypercube definition. Takes a copy of the existing one. Adds each dimension from the selection object (if not already in the hypercube). Sends this off to the server, and calls export to excel on this hypercube.

You end up having your selection fields as separate columns in the excel export. And with the selection values repeated throughout all the rows.

Hope this helps. But, yes, it is a bit fiddly. 😉

Re: Current Selection while export data

Tami — Tue, 22 Sep 2020 14:44:12 GMT

This would be a great add-on. I have seen this done through extensions but would be great to have within QlikSense itself. As users of both QlikView and QlikSense, our organization is use to this feature and it is a big disadvantage in Qlik Sense.

Re: Current Selection while export data

colombari-g — Tue, 10 Nov 2020 17:11:28 GMT

It's totaly necessary. A big regression from QV and very simple to implement...

Re: Current Selection while export data

TimH — Fri, 04 Dec 2020 14:48:58 GMT

Just a reminder that this is still a desired function!

Re: Current Selection while export data

andyhudson — Tue, 05 Jan 2021 15:34:25 GMT

This is an essential requirement for us. Please add this feature.

Re: Current Selection while export data

ThomasKrummenacher — Mon, 08 Mar 2021 12:41:19 GMT

I fully agree with the previous speakers, please implement this functionality.

Re: Current Selection while export data

thereseolsson — Tue, 06 Apr 2021 14:01:24 GMT

+1 on this, a feature that is very much needed.

Re: Current Selection while export data

Keto — Tue, 27 Jul 2021 07:08:06 GMT

We need this functionality, it is inconceivable that it is only present in QlikView. Nothing is done yet ...

Re: Current Selection while export data

vegard_bakke — Mon, 16 Aug 2021 09:14:50 GMT

If selections is hard to include, including the Qlik chart footer might give us an option to work around this problem. Context of a chart is vital.

Re: Current Selection while export data

mark_a_jones — Mon, 11 Oct 2021 15:17:26 GMT

This is a much needed feature, seems like a massive oversight!