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

    Exporting to Excel Query

    Chris Hopkins

      Hi,

       

      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.

       

      Excel.JPG

       

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

       

      thanks

        • 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.