1 Reply Latest reply: Apr 27, 2012 10:37 AM by Nicole Smith RSS

    Exporting to Excel Query

    Chris Hopkins



      Can anyone tell me if there is a way of exporting to excel in the correct format?

      Everytime i export to excel, there are some columns that i have to manually convert to a number format.




      The columns with green triangles i have to convert to a number format.



        • Exporting to Excel Query
          Nicole Smith

          If you change the format of the expressions on the Number tab in Qlikview to one of the number formats, they should export to excel as numbers.  You could also use =Num() around your fields or dimensions/expressions to make sure the format of it is a number.