Poblem whith column order Sense to Excel

[chme02]

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.

 

[Raghul]

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

Thanks,

Raghul

[morenoju]

Hi @Raghul ,

Do you know if this bug was ever addressed? Do you have a link to it so I can track it?

Thanks much!

Juan