Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Export Table Data to Excel - Column Order Changes

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?

Tags (1)
11 Replies
reddys310
Honored Contributor II

Re: Export Table Data to Excel - Column Order Changes

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.

Not applicable

Re: Export Table Data to Excel - Column Order Changes

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.

reddys310
Honored Contributor II

Re: Export Table Data to Excel - Column Order Changes

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.

amir_vitman
New Contributor

Re: Export Table Data to Excel - Column Order Changes

Hi,

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

Not applicable

Re: Export Table Data to Excel - Column Order Changes

Not fixed in v2.2. 

amir_vitman
New Contributor

Re: Export Table Data to Excel - Column Order Changes

Hi,

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

lynn_mcclurg
New Contributor

Re: Export Table Data to Excel - Column Order Changes

Hello,

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

gladi-cz
Contributor

Re: Export Table Data to Excel - Column Order Changes

Hi,

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

Thanks,

Petr

tomboucher
New Contributor

Re: Export Table Data to Excel - Column Order Changes

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

Community Browser