topic Creating an Excel Report in QlikView

Creating an Excel Report

Mon, 11 Apr 2011 10:49:04 GMT

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

Creating an Excel Report

Mon, 11 Apr 2011 10:55:50 GMT

Hi,

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

Thanks & Regards

Creating an Excel Report

ashfaq_haseeb — Mon, 11 Apr 2011 10:58:06 GMT

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

Creating an Excel Report

Mon, 11 Apr 2011 11:10:59 GMT

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

Creating an Excel Report

Mon, 11 Apr 2011 11:21:05 GMT

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

Creating an Excel Report

nathanfurby — Mon, 11 Apr 2011 11:28:03 GMT

Make sure security settings allow system access.

Creating an Excel Report

Mon, 11 Apr 2011 11:53:44 GMT

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

Creating an Excel Report

nathanfurby — Mon, 11 Apr 2011 12:04:35 GMT

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.

Creating an Excel Report

Mon, 11 Apr 2011 12:13:00 GMT

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

Thanks

Creating an Excel Report

Mon, 11 Apr 2011 15:04:49 GMT

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

Creating an Excel Report

nathanfurby — Mon, 11 Apr 2011 15:17:23 GMT

You should be able to do exactly as you require using the example. You need to explain exactly what it is you want to do if you think that this is not the case.