topic Re: Changed column sequence after data export in App Development

Changed column sequence after data export

ahidu1030 — Thu, 12 Apr 2018 08:50:21 GMT

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?

Re: Changed column sequence after data export

kaanerisen — Thu, 12 Apr 2018 09:19:15 GMT

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.

Re: Changed column sequence after data export

ahidu1030 — Thu, 12 Apr 2018 09:30:15 GMT

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.