Exporting to Excel Query

[hopkinsc]

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

[#2]

could you please post the article, I do not have access to salesforce. Thanks

[#3]

could you please post the article, I do not have access to salesforce. Thanks

[#4]

hi,

could you please post the article, I do not have access to salesforce. Thanks

[#5]

Try the following.

Select Help > About QlikView > Right Click on the QlikView Icon on the bottom left hand corner > Select "ExcelExportMixedAsText" > Change the value from 1 to 0 > Select Set

Then try exporting your data to excel.

Hope this helps!

[Joaquin_Lazaro]

Please, log-in in the Community.

On the first menu select QlikView Sites/Customer Portal ... and open in a new window.

Paste the previuos link on the recent window.

[#7]

it works!!!

[#8]

When you set ExcelExportMixedAsText = 0. The missing value is exported as Number, when you populate missing value with 0