5 Replies Latest reply: Dec 22, 2014 4:30 AM by AVIRAL NAG RSS

    SQL View export to excel, changed number formats

    Michiel van de Goor

      I have to use excels as development sources. Access to the database is not possible.

      These excels are created by exports from a sql server view.

      The latest excel I received loads dates and number different from previous excels and therefore the data is not calculated right. Also, special characters are shown different.

       

      I suspect this has something to do with the export parameters to excel.

       

      Or is this a QlikView issue and if so, how can I solve this?

       

      Examples:

      The dates as of 30-11-2014 are from the latest excel file.

      537143_2.jpg537143_1.jpg