Export to Excel issue

AbhijitBansode — Tue, 20 Jan 2015 06:02:36 GMT

Hi Experts,

I come across a strange problem.

I've 4 numeric fields in the SQL Server Database. When I do Select * from database and show those fields in Straight table as dimensions, they are exporting as numeric columns in Excel file.

Now I've created a qvd file of the same data, when I load same fields from qvd file listing all the column names in the Load statements, the problem occurs.

This time when I show the same set of fields in Straight Table, they are being exported as string columns.

I'm not doing any transformation on these columns neither there is any variable defined which sets the number format.

So, not sure why the datatype of these columns getting changed.

Now, I've tried Load * from qvd file. and it's working absolutely fine. In this case all the fields being exported as numeric.

Any idea why this is happening and how do I avoid this.

Thanks,

AVB

Re: Export to Excel issue

AbhijitBansode — Wed, 21 Jan 2015 10:16:09 GMT

Solved this.

topic Re: Export to Excel issue in QlikView

Export to Excel issue

Re: Export to Excel issue