1 Reply Latest reply: May 22, 2017 6:58 AM by Raghul Chandrasekaran RSS

    Poblem whith column order Sense to Excel

    Christoffer Melander


      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.


        • Re: Poblem whith column order Sense to Excel
          Raghul Chandrasekaran

          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