Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Not applicable

Creating an Excel Report

Hi,

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

Thanks & Regards

Highlighted

Creating an Excel Report

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

Highlighted
Not applicable

Creating an Excel Report

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

Creating an Excel Report

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

Highlighted
Specialist
Specialist

Creating an Excel Report

Make sure security settings allow system access.

Highlighted
Not applicable

Creating an Excel Report

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

Highlighted
Specialist
Specialist

Creating an Excel Report

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.

Highlighted
Not applicable

Creating an Excel Report

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

Thanks

Highlighted
Not applicable

Creating an Excel Report

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