Changed column sequence after data export

[ahidu1030]

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?

[kaanerisen · Accepted solution]

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]

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.