Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor II

Poblem whith column order Sense to Excel


Hi, I have a problem when trying to export to Excel in Sense. I the table I have a measure in column 2 (need a row number based on current selection). The problem is that when exported the column is no longer nr2, it is now sorted by dimensions and measurements.

I need them to be in the original order. How do I get that? I’m currently using the built in export data in Sense.


Tags (1)
1 Reply

Re: Poblem whith column order Sense to Excel

Hi Chris,

Currently this is an expected behavior of Export Data in Qlik Sense. The columns are ordered in such a way that Dimension Columns are kept left and Measure Columns are kept right.

Example : If we have Dim1, Meas1, Dim2, Meas2 . The export data column order will be Dim1, Dim2, Meas1, Meas2.

A bug as been reported already, this might be fixed in future releases. Meanwhile you can also refer any extensions which might help you on this issue.

Qlik Branch



Community Browser