Export to Excel

[#1]

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,

[deepakk]

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

[#3]

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,

[deepakk]

hi

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

[#5]

Hi,

its through error Object required: 'obj'.

Any best suggestins pls.

Thanks,

[deepakk]

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.

[#7]

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,

[deepakk]

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

[#9]

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,

[deepakk]

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.