topic Re: Export button help?????? in QlikView

Export button help??????

amit_saini — Thu, 06 Mar 2014 06:48:41 GMT

Hi Folks,

I'm having a application A3.qvw (Please see the attachment) , here I'm having a straight table where I'm calling few fields as dimension & expression.

My client want me to create a Export report button for this application and on clicking this export button he want output as Report.xls (Please see the attachment)

Please help me how to create this Export report button to get the desired output as mentioned in the attachment.

Thanks in advance .

Re: Export button help??????

Thu, 06 Mar 2014 07:02:09 GMT

Hi,

I am not able to open the attached xls file. Can you attach it again?

But I can suggest that you can create a chart/table of the required format in qlikview itself and then export it to excel using the default qlikview functionality of "Send to excel" or you can write a macro/trigger on a Export button which you have in qvw file.

Hope this helps!

Re: Export button help??????

MK_QSL — Thu, 06 Mar 2014 07:08:11 GMT

Please check enclosed file..

Re: Export button help??????

Thu, 06 Mar 2014 07:31:18 GMT

Do you want to export particular straight table to be exported then you can directly use the export to excel option from the caption tab.

Re: Re: Export button help??????

amit_saini — Thu, 06 Mar 2014 07:34:27 GMT

Hi Shyamal,

Please find the attachment again. Yes may be you are right but I'm sorry i really don't know how to create this inside qlikview itself.

Thanks,

Re: Export button help??????

amit_saini — Thu, 06 Mar 2014 07:39:14 GMT

Hi Manish,

When I'm clicking to the export button it is diverting me to the macro page and pointing towards :set XLApp = CreateObject("Excel.Application") this option.

Please suggest what shall I do ????

Thanks,

Re: Export button help??????

Thu, 06 Mar 2014 08:07:23 GMT

Hi Amit,

I am getting some run time error while opening the xls file. But anyways, it opens.

I saw the the contents of xls file and I am not sure what kind of a report is required there. Can you explain what columns you need from your qvw file and the format in which you require the report?

Re: Export button help??????

amit_saini — Thu, 06 Mar 2014 08:34:33 GMT

Hi Shyamal,

Report.xls is the template which is created by client itself, my requirement is that I need to link this template with my qvw application so that data from the qvw can be seen inside this template.

Foe example: Complain No. is one of my field in the qvw straight table , the content of this should occur under

1) REASON IMPROVEMENT PROJECT WAS CHOSEN of Report.xls

Similarly rest of the headings inside Report.xls is having data from other fields present in qvw.

Please suggest me solution for this, how this can be done ????

Thanks,

Re: Export button help??????

Thu, 06 Mar 2014 08:44:25 GMT

Amit you mentioned in an earlier reply that

"Foe example: Complain No. is one of my field in the qvw straight table , the content of this should occur under

1) REASON IMPROVEMENT PROJECT WAS CHOSEN of Report.xls"

How is it possible for us to help populate the excel document when the fields do not map explicitly through name. Would you be so kind as to tell us what field in QlikView represents what field in the excel spreedsheet.

This is not a difficult task to achieve, just need to have all the information at hand to correctly map as an excel output

Cheers,

Byron

Re: Export button help??????

Thu, 06 Mar 2014 08:49:45 GMT

Hi Amit,

As Byron mentioned, need to have all the column mappings then only it will be possible to create specific report and then have it in excel.

Re: Export button help??????

MK_QSL — Thu, 06 Mar 2014 09:11:39 GMT

There could be one of the few reasons as below..

1) No Microsoft Office installed in your PC.

2) If you check below line in the Macro..

set MyTable = ActiveDocument.GetSheetObject("CH02")

You need to change CH02 to your actual table's ID.

You can find the same in your general tab of specific object.

3) In Macro EDIT MODULE (CTRL + M)

Requested Module Security should be System Access

Current Local Security should be Allow System Access

Please try above suggestion and let me know if still you have problem.

Re: Export button help??????

amit_saini — Thu, 06 Mar 2014 09:27:27 GMT

Hi Byron\Shyamal,

Mentioned below are the headings in Report.xls (In Bold) template and in brackets I'm mentioning the fields (Please see yellow ones) which i need to linkfrom qvw application

1) REASON IMPROVEMENT PROJECT WAS CHOSEN ([Complaint No.])

2) INITIAL / CURRENT CONDITION (Plant)

3) TARGET CONDITION / GOAL(Date)

4) IMPROVEMENT INVESTIGATION / CONTAINMENT( [Problem Desc.])

5 WHY ANALYSIS / TOP ISSUES( Containment)

5) IMPROVEMENT ACTIONS / COUNTERMEASURES ([Complaint Owner])

6) IMPLEMENTATION PLAN ([Info])

7) FOLLOW UP/ CONFIRMATION OF IMPROVEMENT EFFECT ( [Complaint Title/Issue])

😎 KEY LEARNING POINTS ([Customer / Cost center])

Re: Export button help??????

Thu, 06 Mar 2014 09:37:04 GMT

Thanks busy working on it.

And with regards to the headings in the report.xls i.e. project title, team ? Or this something you will do yourself?

Cheers,

Byron

Re: Export button help??????

lawrenceiow — Thu, 06 Mar 2014 09:47:52 GMT

Hi AS,

Depending on what your Excel skills are like I think you should consider the suggestion from prya sane (and Shyamal Pandit) - create of Straight Table of the data you need to export and then use the Export to Excel option.

Then use the exported spreadsheet as a data source for the report.xls template. The User would be expected to re-link (or import) to the template file each time they export a new dataset in this way.

Just incase you don't know about the export to excel option, make sure you are displaying the Caption and tick the Send to Excel box....

Re: Export button help??????

amit_saini — Thu, 06 Mar 2014 09:48:48 GMT

Thanks a lot Byron for your help, yes rest I will do myself.

Thanks,

Re: Export button help??????

amit_saini — Thu, 06 Mar 2014 10:03:53 GMT

Hi Lawrenceiow,

Thanks for your suggestion, I know this export but my requirement is totally different. It is not just a simple export from qvw straight chart. I need a automated button which will help me to get desired data from qvw into the Client template.

Thanks,

Re: Re: Export button help??????

amit_saini — Thu, 06 Mar 2014 10:14:51 GMT

Hi Manish,

Yes there was problem with point number 3 of yours , I corrected it ,I'm getting the export but a normal one not the desired one.

Your Export looks like this:

Complaint No.	Plant	Date	Customer / Cost center	Complaint Owner	Complaint Classification	Info	Complaint Title/Issue	Problem Desc.	Containment
C-2011-0406	018 Amit Info	24.May.2011	CHRYSLER DE MEXICO S,A,DE C,V, REFORMA 1240, SANTA FE MEXICO, DISTRITO FEDERAL	Amit,Saini Phone: (519) 251-7576	-	Contact: XYZ CHRYSLER DE MEXICO S,A,DE C,V, REFORMA 1240, SANTA FE XYZ,ABC Complaint Title: hole in fuel tank 24.May.2011 Customer Complaint Number: Part#: 720234 Part Desc: TANQUE DJ 35G Diesel 05147789AB Qty Suspect:1900 Qty Not OK:2 Qty Reworked:0 Qty Returned:1 Qty PPM Relevant:2	hole in fuel tank	Problem Desc.:Barreno en tanque de gasolina Defect Desc.:Amit Team/Individual to customer: J. Montalvo/ T.Delgado, C.Jimenez, S.Gonzalez, O. Gordian, A.Marin, J.Lansing Size of problem (ex. dimension): barreno en tanque - See attached picture Sample parts(s) returned to XYZ: [ ]Yes, [ ]No Date: Samples Evaluated by: Date samples evaluated: Sample part(s) shipped to: Not Applicable Date: Samples evaluated by: Date Samples Evaluated: XYZ serial #: Component part #: Not Applicable Component serial #: Not Applicable When was suspect product produced?: Was the suspect product previously repaired at the customer? Yes [ ], No Does the component to final assembly serial # association match? (If applicable) Yes[ ] Not Applicable	24h-containment 24h-containment Date:24/5/11 Work Instruction posted at each inspection operation: Yes, [ ]No List locations: Warehouse, Production line Date: 24/5/11 Quarantine GOODS @ XYZ Description: Sorted all stock # of parts sorted: 300 # of parts rejected: 0 % of parts rejected: 0 Date: May 24-26, 2011 All stock @ customer sorted # of parts sorted: 800 # of parts rejected: 0 % of parts rejected: 0

But Required one should looks like Report.xls (Please see the attachment)

Thanks a lot for your time and help.

Re: Export button help??????

amit_saini — Fri, 07 Mar 2014 04:55:51 GMT

Hi Folks,

Kindly help me on this.

Thanks,

Re: Re: Export button help??????

lawrenceiow — Fri, 07 Mar 2014 08:54:03 GMT

Is this what you mean?

Create a button,
Add an external action to export
1. specify the fields you need to export as a record.
2. specify the path and filename of the export file.
link your report.xls file to the file you specified at 2b above.
Make sure you select one record (eg the complaint number)
Click the button you created above.

Take a look at the attached files: Report.xls is your template file which is linked to book1.xls which was exported as described above.