Export Excel or csv

[#1]

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

[kushalthakral]

Hi Steve

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

Regards

Kushal Thakral

[buzzy996]

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

[Chanty4u]

u can export

in script  using

STORE filename into  c:\path.csv   

or txt  or xls   u can give.

[andrespa · Accepted solution]

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

[#6]

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.

[#7]

Thank you Chanty. 

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

[Chanty4u]

Cool