Qlik Community

Qlik Sense App Development

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

ahidu1030
New Contributor II

Changed column sequence after data export

Hello everyone,

I have a problem.

I prepared a flat table with certain sequence of columns, which is a combination of dimensions and measures.

In "Sorting" I have adapt this sequence as well. But when I export data in Excel, the sequence is changed.

Can somebody tell me why? Is it due to combination of dimension and measure? And how can I really download the table 1:1 without change of column sequence?

1 Solution

Accepted Solutions
kaanerisen
Contributor III

Re: Changed column sequence after data export

Hi Xiaoyu,

https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/DataExport/export-data.htm

When you export tables from Qlik Sense, the resulting .xlsx files will have dimensions before measures, regardless of the order in the Qlik Sense table visualization. This is due to how the Qlik Sense engine service associates data. To work around this current limitation, create calculated dimensions from your measures and use the dimensions instead of measures in the table.

2 Replies
kaanerisen
Contributor III

Re: Changed column sequence after data export

Hi Xiaoyu,

https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/DataExport/export-data.htm

When you export tables from Qlik Sense, the resulting .xlsx files will have dimensions before measures, regardless of the order in the Qlik Sense table visualization. This is due to how the Qlik Sense engine service associates data. To work around this current limitation, create calculated dimensions from your measures and use the dimensions instead of measures in the table.

ahidu1030
New Contributor II

Re: Changed column sequence after data export

Hello Kaan,

Thanks for the reply.

Ok, for some column if I change from dimension to measure, it works. But for some other it doesn't work.

E.g.

The formular is:

= if ( sum ([INVL.Purchase Order Quantity])=0 and sum ([INVL.Delivery Quantity])> 0, 'Y', 'N')

What I did is just copy the formular and paste to the dimention I create.

Community Browser