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

[Anonymous]

Maybe you should consider Licences for those people .

You use QlikView (great product) and then export it (and manipulate since the export is not numeric correct), create filtering possibilities . . . it's a lot of work and not fun to do.

I say . . . Document CAL

[hopkinsc]

I agree that licenses should be provided. Although our field staff as we have over 100 field staff licenses would be very expensive

[m_woolf]

Use a macro to send the data to Excel and do the formatting in the same macro.

[Anonymous]

Using a macro is a possible solution I guesse . . . especially if you have to do this stuff for over 25 times a week!!
If licenses is not a solution and you really wish for a workable solution for yourself . . . use a macro.

We chosen not to do so, because the effort we had to put in this was to much.

Also we had the problem we weren't allowed to install excel functionality on our server 😉

[#6]

You many need to specify exactly how you want to export it:

EG

For your Delivery Note No. field:

num([Delivery Note No.],'#,##0.0')

or for Dates use:

date(YourDateField,'DD/MM/YYYY')

[Anonymous]

using this in the expresion doesn't work . .. 

[#8]

It would need to be used in the dimensions...

[Anonymous]

The dimensions is not really my issue . . . it is the expresions which give the problem

[Joaquin_Lazaro]

Hi:

It was a QV bug, in the next version it will be solved ... read this pdf

[Joaquin_Lazaro]

Hi:

I've found the way to export numeric fields as numeric cells ... but unformatted.

After instal QV 11 SR2 you must following the instructions on this article https://eu1.salesforce.com/articles/Basic/How-to-export-data-to-excel-as-number-in-version-11?popup=... at the customer portal.