topic Re: Export Table Data to Excel - Column Order Changes in App Development

Export Table Data to Excel - Column Order Changes

Mon, 08 Feb 2016 22:24:51 GMT

In Qlik Sense, export table data to Excel, regardless of the column order in a table, the columns with Dimension values always present in the spreadsheet to the left of columns which contain Measure values. For example, if I have a table with three columns aligned in the order from left to right, Measure Value 1, Dimension Value 1, Dimension Value 2 and export to Excel, the columns appear in the spreadsheet from left to right, Dimension Value 1, Dimension Value 2, Measure Value 1. Is there a workaround I can apply?

Re: Export Table Data to Excel - Column Order Changes

reddy-s — Tue, 09 Feb 2016 10:47:16 GMT

Hi Dan,

The export of data should be in the order of fields in the properties panel. Are they ordered the way you need?

Thanks,

Sangram.

Re: Export Table Data to Excel - Column Order Changes

Tue, 09 Feb 2016 15:53:20 GMT

Yes, they are ordered as desired. After experimenting, I found that columns containing Measure values always are placed to the right of column containing Dimension values. This appears to be a bug in the export function.

My observation is that columns containing Measure values always appear to the right side of the spreadsheet while the columns containing Dimension values appear in the left side of the spreadsheet. I am able to reorder the Dimension columns within the group of Dimension columns and am able to reorder the Measure columns within the group of Measure columns and the Export to Excel reflects the reordering, but when a Measure column is reordered to a position within the group of Dimension columns the Export to Excel fails to follow the new ordering. It keeps the Measure column within the group of Measure columns.

Re: Export Table Data to Excel - Column Order Changes

reddy-s — Wed, 10 Feb 2016 09:58:39 GMT

Hi Dan,

Yes, there are a few issues with the export to excel functionality, hope fully they will be fixed in the coming release.

Thanks,

Sangram.

Re: Export Table Data to Excel - Column Order Changes

Anonymous — Mon, 29 Feb 2016 08:52:11 GMT

Hi,

I have the same issue. Do you know if that bug was fixed in v2.2?

Re: Export Table Data to Excel - Column Order Changes

Mon, 29 Feb 2016 18:57:02 GMT

Not fixed in v2.2.

Re: Export Table Data to Excel - Column Order Changes

Anonymous — Tue, 05 Apr 2016 09:47:58 GMT

Hi,

I have the same issue. Do you know if they working on fixing this bug?

Re: Export Table Data to Excel - Column Order Changes

lynn_worsley — Fri, 17 Mar 2017 23:47:10 GMT

Hello,

We are on Qlik Sense 3.2 and having the same issue with the Excel export. Is there an update?

Re: Export Table Data to Excel - Column Order Changes

gladi-cz — Mon, 19 Feb 2018 12:11:14 GMT

Hi,

mto‌‌ There is at least workaround, how to fix column order?

Thanks,

Petr

Re: Export Table Data to Excel - Column Order Changes

Anonymous — Mon, 19 Feb 2018 12:32:12 GMT

Hi, just to keep this thread open and running, I too am experiencing this issue, and whilst what Sense is doing makes sense(no pun), I really would like to be able to maintain the field order when exported to Excel.

Cheers,

Tom

Re: Export Table Data to Excel - Column Order Changes

jerifortune — Fri, 16 Mar 2018 13:09:50 GMT

Is there any workaround of this issue? I have a report with order of straight table being required requirement. However, the export to excel is rearranging the column order.

Thanks

Re: Export Table Data to Excel - Column Order Changes

Anonymous — Wed, 07 Nov 2018 13:38:44 GMT

Hi.

Has this bug been fixed yet? We are about to go to the latest version of Qlik Sense.

Many thanks