topic Exporting to Excel Query in QlikView

Exporting to Excel Query

hopkinsc — Thu, 26 Apr 2012 08:25:30 GMT

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.

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

thanks

Exporting to Excel Query

Nicole-Smith — Fri, 27 Apr 2012 14:37:06 GMT

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.