idea Re: Export total straight table to Excel in Suggest an Idea

Export total straight table to Excel

mwanders — Wed, 25 Nov 2020 15:38:50 GMT

Hi Qlik,

With the export to Excel function Qlik doesn't export the column total with a straight tabel. With the export of a pivot table the total of a dimension is exported.

Maybe a good idea to export the column total of a straight table. My customers are creating now their own totals in Excel and cost time.

Greetings

Martijn Wanders

Re: Export total straight table to Excel - Status changed to: Open - Collecting Feedback

Caique_Zaniolo — Mon, 20 Apr 2020 19:40:41 GMT

Hi, this is not in our short-term roadmap. Our current investments into making Enterprise Reporting an awesome and important part of the product result in a number of tradeoffs and we hope to get back to this item at some point. Please continue to show your support for this idea.

Re: Export total straight table to Excel

SchalkB1 — Tue, 28 Apr 2020 10:25:52 GMT

Good day

I have received numerous requests from customers to be able to export the Total in a Qlik Sense Table to Excel.

I subsequently searched through Qlik Community and various conversation threads where I have noticed that this was identified as a requirement/suggestion in 2016 already. Thereafter there were numerous posts indicating that it is either solved, or suggested to upgrade to the latest version or that it is by design (what type of design is this?)

I have just upgraded to April 2020 and what a disappointment that it is still not enabled. I do think that Qlik should priorities this in their short-term road map as I am now confronted with statements that the competitive products can do it. This is a real requirement and not just a nice to have anymore.

Feature Request ID: ID: 1434 - QlikSense - export totals row in table to Excel.

Feedback: Qlik has previously received feedback on this feature and recorded the request for future review. For up to date information, please contact support at (support.qlik.com) referencing this article.

May I ask for official feedback from Qlik(that I can share with my clients)on the progress of the above request.

Thanks in advance

Re: Export total straight table to Excel

martingries — Tue, 28 Apr 2020 10:36:36 GMT

Good idea and even better if we could have the option to show the selections in the Excel file (like in QlikView)

Re: Export total straight table to Excel

Eva_Z — Thu, 07 May 2020 13:08:16 GMT

I have the same need, my company used QlikView and we are moving to QlikSense, but the lack of totals and selections info in the export is a big problem for a lot of users.

I hope that Qlik reconsiders the decision and prioritize this point, or they'll end up losing a lot of users.

Re: Export total straight table to Excel

IsakBosman — Wed, 22 Jul 2020 07:58:04 GMT

I support the above mentioned request. It will definitely add a lot more value to the Qlik Sense offering.

Re: Export total straight table to Excel

Steven_Haught — Wed, 22 Jul 2020 18:00:45 GMT

This seems like a simple addition that would be a good win. I agree it would be nice to have this.

Re: Export total straight table to Excel

stiles16 — Wed, 05 Aug 2020 19:40:08 GMT

I'm asked this constantly after we converted all our apps from QV to QS. The users don't like adding the totals back in and sometimes those total row values aren't simple summary functions based on all rows.

Re: Export total straight table to Excel

AminRayani — Wed, 26 Aug 2020 05:55:45 GMT

Failed to understand why it is not there in the first place. I do not understand why Qlik has to even review this requirement (Just put it in, as simple as that). It is straight forward functionality (Pivot tables does it) they have missed to put in. One of many set backs experienced moving to QS from QV.

Re: Export total straight table to Excel

jcamps — Wed, 09 Dec 2020 18:07:55 GMT

This is so clearly a product gap, that has bee there from Qlik Sense 1.0 and still lacking. This is unexplainable. Plus, as a feature, it is in some aspects an excuse to use other visualization platforms.

Re: Export total straight table to Excel

CosminaBICS — Fri, 12 Feb 2021 09:43:13 GMT

I support the above mentioned request.

It is very annoying if we export columns from QS report that we don’t have the total figures. Means for every export we need to add manually the formula’s to have the totals & weighted values (%).

Re: Export total straight table to Excel

PedroC — Tue, 02 Mar 2021 20:28:55 GMT

Qlik should consider this as a serious gap.

I've got about 500 Qlik dual licencing users and you can bet that none of them understand why this issue hasn't been solved yet.

Qlik sense has three mayor issues qlik should focus on, export of totals in straight tables, cyclic groups and printing/pdf exporting when printing data exceeds screen area.

Thanks in advance

Re: Export total straight table to Excel

NemoAndStitch22 — Mon, 26 Apr 2021 12:55:09 GMT

I would really like this feature added too, it's driving me nuts having to add them and having to recalculate the formulas to get correct %s.

Re: Export total straight table to Excel

jorgenpet — Thu, 01 Jul 2021 08:16:59 GMT

Strongly agree!

Re: Export total straight table to Excel

francesco_menin — Tue, 20 Jul 2021 14:42:22 GMT

Being following this closely, hope it moves on soon...

Re: Export total straight table to Excel - Status changed to: Open - In Development

Ian_Crosland — Tue, 11 Jan 2022 11:09:29 GMT

Re: Export total straight table to Excel

robertomontanar — Tue, 01 Feb 2022 21:29:52 GMT

My clients don't understand why Qlikview does it and Sense doesn't. Me too urge the implementation of this function

Re: Export total straight table to Excel

Digvijay_Singh — Tue, 01 Feb 2022 21:40:12 GMT

FYI, Feb 2022 release has this feature added to have total column exported to Excel.

Re: Export total straight table to Excel

Digvijay_Singh — Tue, 01 Feb 2022 21:41:39 GMT

I downloaded the technical preview version and did a little test just now.

Re: Export total straight table to Excel - Status changed to: Delivered

Patric_Nordstrom — Sun, 20 Feb 2022 18:45:32 GMT

Delivered as of February 2022 release. Download as Data has a formatting option that will include totals if present.