topic Re: Export to Excel as ; separated in QlikView

Export to Excel as ; separated

Mon, 16 Dec 2013 11:28:55 GMT

Hi,

When I export data from Qlickview to Excel and the number of rows is higher than 65 thnd then I get data in Excel as an imported ; separated file. Every row lookes like this:

21071058;1700;7592302090;1;42,34;25,00%

I am using Office 2007 that can handle over a million records but Qlickview doesn't seem to care. How or where can I change this?

Best regards,

Michel van de Vosse

Re: Export to Excel as ; separated

Mon, 16 Dec 2013 11:34:05 GMT

Hi,

What version of QlikView are you using and are you exporting via a Web Browser or QlikView Client?

Thanks,

Re: Export to Excel as ; separated

Peter_Cammaert — Mon, 16 Dec 2013 11:35:22 GMT

There are a number of places where you can export/send QV data to Excel. Which one are you using? Desktop/Server/Object/Script/Macro?

Peter

Re: Export to Excel as ; separated

Mon, 16 Dec 2013 11:37:43 GMT

I am using version 11.20 and I am exporting with the export to qlickview button opn the top right of my pivot table.

Re: Export to Excel as ; separated

Mon, 16 Dec 2013 11:46:13 GMT

Sorry to be pedantic but are you in a Web Browser (if so which one IE/Chrome/etc) are you using AJAX, JAVA, Plug-in... or are you using a QlikView Client installed on your local machine?

Sadly there are a number of ways to export to Excel and I personally have never seen an issue like you describe. So to know how you have encountered this is very helpful.

If possible maybe posting the document you are having this issue with as this might allow others to replicate what you are doing in their environment.

Thanks,

Re: Export to Excel as ; separated

Anonymous — Mon, 16 Dec 2013 11:50:57 GMT

Michel

Qlikview uses BIFF format for excel exports which is limited to 64 thousand rows.

This cannot be changed

Also see this thread, http://community.qlik.com/message/29209#29209

Best Regards, Bill

Re: Export to Excel as ; separated

Mon, 16 Dec 2013 12:06:20 GMT

Oh Sorry, desktop installation, but recording to Bill it doesn't really matter because of the BIFF format.

Thanx Bill for your answer, Hope Qlicktech solves this in the next update.