Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating an Excel Report

Hi,

I have a QV document to show more info into several list boxes and some pivot charts. I want to produce an Excel report with the data collected from these objects. The automatic feature Send to Excel for a chart it isn't enough for my purposes because I need to get some data from the list boxes.

Any helps to me to solve this issue, please? Thanks

10 Replies
Not applicable
Author

Hi,

You can try the attached application, Hope this will solve ur query.

Thanks & Regards

ashfaq_haseeb
Champion III
Champion III

Hi

After making appropriate selections

Right click on the table box or pivot table etc. and then select send to excel.

By this all of your selections for that particular sheet will be send to excel file.

hope that helps

Regards

ASHFAQ

Not applicable
Author

Hi Ashfaq,

in the list boxes are present the code and not the description of a dimension linked to the fact table. Moreover, in the fact table aren't present all necessary data.

Are you sure about your tip?

Thanks

Not applicable
Author

Hi upendra11,

I have a look to your module. It seems very interesting but when I click on your button nothing is exported to Excel.

I have QV 10 and Excel 2010.

Thanks

nathanfurby
Specialist
Specialist

Make sure security settings allow system access.

Not applicable
Author

Hi,

inside the module the current local security is set to system access allowed.

Inside the User Preferences, Security tab, are checked the 1st (macro module), the 3rd (run) and the 5th option (configure execution from macro).

When I click on the button, in QV 10 below I can see the message that the macro is executing and then Excel 10 - cartel 1 is opened. Nothing is written on the sheet 1.

Thanks

nathanfurby
Specialist
Specialist

Sorry can't help. This is working for me in QV 9 SR4 and Excel 2007.

If by Excel 10 you mean Excel 2010 - you might want to research VB Script in conjunction with this version. I know there are some differences/guidelines.

Not applicable
Author

Yes, I have had a mistake but before I have written Excel 2010.

Thanks

Not applicable
Author

Ok. I'm able to use successfully the module with QV 10 and Excel 2010. I'm using Excel in Italian language and I have translated the text for "Sheet1" into "Foglio1".

But I'd like to create an unique report on Excel as a data union from more list boxes and charts and not to have a spreadsheet originated as a copy and paste operation.

Thanks