topic Export Excel or csv in QlikView

Export Excel or csv

Wed, 30 Mar 2016 15:06:33 GMT

Hello,

I have two QlikView documents with very similar models; i.e., nearly identical tables and fields.

On each document I create an exportable Table Box with two identical fields, one is a timestamp the other a string.

When I click on the Send to Excel icon for one of the boxes, it downloads a (.xls) file, but when I click the icon on the other, it downloads a (.csv) file. I would like both to download in Excel. What can I do to insure this happens?

Regards,

Steve

Re: Export Excel or csv

kushalthakral — Wed, 30 Mar 2016 15:08:48 GMT

Hi Steve

Can you please share the application or screen shot for better understanding.

Regards

Kushal Thakral

Re: Export Excel or csv

buzzy996 — Wed, 30 Mar 2016 15:14:01 GMT

not sure how ur getting .csv file,can u follow to active the below option on ur 2nd table box and try to export?

Re: Export Excel or csv

Chanty4u — Wed, 30 Mar 2016 15:18:47 GMT

u can export

in script using

STORE filename into c:\path.csv

or txt or xls u can give.

Re: Export Excel or csv

andrespa — Wed, 30 Mar 2016 16:24:03 GMT

Hi Steve,

I had a similar issue some time ago. I think it happens because the amount of data. I suposse your first table has a high level of granularity and your second one has a finer one. I think qlikview assume that for huge amount of data the better way of handling this is to put it on a CSV file.

The solution is the one proposed by Chanty, you can right-click on export and decided to exported as .xls.

Hope it helps,

Andrés

Re: Export Excel or csv

Wed, 30 Mar 2016 18:27:46 GMT

Thanks Andres.

I suspected it might be something like that. Since it's not documented anywhere that exporting X amount of data results in exporting as Excel, but exporting > X data exports as csv, I could only guess that this might be happening.

Thanks again.

Re: Export Excel or csv

Wed, 30 Mar 2016 18:30:36 GMT

Thank you Chanty.

Of course my client would rather click the single XL icon, but I'll make them aware of this option.

Re: Export Excel or csv

Chanty4u — Thu, 31 Mar 2016 04:46:07 GMT

Cool