topic Export to Excel in QlikView

Export to Excel

Tue, 09 Nov 2010 11:43:18 GMT

Hi,

I have a dashboard along with that I have export to excel button.

But when I click on the export to excel I am getting only 1000 records and I am missing another 400 records.

Is there any settings in the properties?

Thanks,

Export to Excel

deepakk — Tue, 09 Nov 2010 12:30:30 GMT

How are you sending it to excel . Are you using Export to Bifff option or Using Excel Object ?

Can you attach the sample file. We can help you out.

Also check version of Qlikview . Recommended : QV9 SR5 or SR6

Export to Excel

Tue, 09 Nov 2010 15:55:35 GMT

Deepak, I have export to excel button.

I am copying (ctrl+v) the data in to excel once i click on the button.

I am getting only 1000 records and I am using V8.2.

Pls let me know is there any settings or not?

Thanks,

Export to Excel

deepakk — Wed, 10 Nov 2010 05:11:40 GMT

I have not worked on QV8.2.

hence not sure if the below code works. But this would be a better approach. Try it out.

set obj = ActiveDocument.GetSheetObject("CH01")
obj.ExportBiff "C:\test.xls"

Deepak

Export to Excel

Fri, 12 Nov 2010 09:38:56 GMT

Hi,

its through error Object required: 'obj'.

Any best suggestins pls.

Thanks,

Export to Excel

deepakk — Fri, 12 Nov 2010 09:52:50 GMT

the CH01 is the objectID... if you want to exporta pivot table first check its object id . you will find in Genral properties of the pivot table.

Every object in QLikview has an Object ID and you will find it the General Properties tab (on the extreme right)

Use the object id in place of CH01 and you will abe able to export the file.

Export to Excel

Fri, 12 Nov 2010 10:01:22 GMT

Deepak,

still have some problem with the code.

I am just taking the BUTTON object and selecting Launch / Export in Function. In Export tab I am adding whatever field I want it in excel.

but records are getting only 1000 why am I missing records.

Thanks,

Export to Excel

deepakk — Fri, 12 Nov 2010 10:10:29 GMT

I am not sure about the problem which you are facing.

But the best approach would be Create a table or pivot chart add the required fields into it and

use the above code.

Let em know if you have any queries

Export to Excel

Thu, 18 Nov 2010 10:05:39 GMT

Hi Deepak, I did the same but I feel it should be in button.

I am not sure where is the problem in export function.

Thanks,

Export to Excel

deepakk — Thu, 18 Nov 2010 10:11:44 GMT

I am not sure if we can write complex expressions in Export button.. Hence I always prefer the Exportbiff.!!

If you can attach the sample application I can check and recommend the best possible solution.

Export to Excel

Thu, 18 Nov 2010 10:43:55 GMT

Deepak, its just simple requirement.

I have 3 dashboards in my application. I would like take couple of fields from that dashboard and export the data into excel.

But when I export the data into excel using button its coming only 1000 records but as per the source file its having 1800 records.

thats it.

I did not get where I can find restricting the data into excel??

Thanks,

Export to Excel

deepakk — Fri, 19 Nov 2010 05:25:28 GMT

Can you attach the application ?

Export to Excel

Fri, 19 Nov 2010 06:47:30 GMT

Hi,

As I said I am using excel source file and used one button to export the data in to the excel.

There are two options in Export Action settings:

1) Export to File : If I select this option I am getting all the records (Used some local location).

2) ClipBoard : If I select this option I am getting only 999 records excluding the field names.

My question is why we are getting only 999 records if my source file is having more than 1000 records??

pls find the attached qvw file.

Thanks,

Export to Excel

Wed, 24 Nov 2010 08:16:36 GMT

Hi Experts,

Has anyone got a chance to look in to this or any idea to solve it?

Thanks,

Export to Excel

deepakk — Thu, 25 Nov 2010 05:32:01 GMT

hi,

This might be a bug. you can write it down to Qliktech for support.

Export to Excel

Tue, 30 Nov 2010 10:44:32 GMT

I did it, but no response from them.

Thanks,