topic Re: hi, in QlikView

hi,

Wed, 03 Jun 2015 02:41:33 GMT

Hi,

Any idea why my macro to export a chart to excel was working when my Excel was in 2010 but now that I have 2013 in the server,

the macro is only generating 1 line of data in my chart.

My macro is as follows :-

sub Cab()

set Chart = ActiveDocument.GetSheetObject( "CH01" )

"C:\DailyReports\CAB\CAB.xls",5

end sub

Re: hi,

Siva_Sankar — Wed, 03 Jun 2015 03:26:32 GMT

Jenny

Try the below macro replacing with your path.

sub ExportExcel

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportBiff "C:\temp\t.xls"

end sub

Re: hi,

Wed, 03 Jun 2015 04:24:26 GMT

Hi Siva,

With the biff, it is not exporting. Is there a compatibility issue with Excel 2013?

Best regards,

Jenny Tan

MIS Manager

Angliss Singapore Pte Ltd

A member of Bidvest Asia Pacific Group

Mobile: 97839001

DID: 6770 4194

Tel: 6778 8787

Fax: 6770 4126

Email address: tan_jenny@angliss.com.sg<mailto:tan_jenny@angliss.com.sg>

Website: www.angliss.com.sg<http://www.angliss.com.sg/>

<http://www.angliss.asia/>

Re: hi,

Siva_Sankar — Wed, 03 Jun 2015 05:19:28 GMT

Jenny,

Are you trying to run the macro using IE client or AJAX?

Re: hi,

Wed, 03 Jun 2015 06:51:26 GMT

Hi Siva,

The macro is run within Qlikview report after reloading.

Best regards,

Jenny Tan

MIS Manager

Angliss Singapore Pte Ltd

A member of Bidvest Asia Pacific Group

Mobile: 97839001

DID: 6770 4194

Tel: 6778 8787

Fax: 6770 4126

Email address: tan_jenny@angliss.com.sg<mailto:tan_jenny@angliss.com.sg>

Website: www.angliss.com.sg<http://www.angliss.com.sg/>

<http://www.angliss.asia/>

Re: hi,

Siva_Sankar — Wed, 03 Jun 2015 06:58:41 GMT

Ensure that you are granting System Access to your macros in the server through QEMC (System, Setup, QlikView Servers, expand and click, Seucrity tab in the right pane "Allow unsafe macro execution on server" and "Allow macro execution on server" ticked) and in the Macro editor, (Ctrl + M, bottom left drop downs)

Re: hi,

petter — Wed, 03 Jun 2015 07:05:30 GMT

If that is your entire macro nothing will end up in Excel. There shouldnt be compatibility issues with Excel 2013 AFAIK I have used them together with macros for more than a year.

Re: hi,

Wed, 03 Jun 2015 08:15:26 GMT

Hi Jive,

My macro is as follows:-

sub Cab()

ActiveDocument.ClearAll

set Chart = ActiveDocument.GetSheetObject( "CH01" )

chart.exportex "C:\DailyReports\CAB\CAB.xls",5

end sub

With ActiveDocument.ClearAll, it exported only 1 line of data.

But when I commented out ActiveDocument.Clearall, it exported all the data.

Best regards,

Jenny Tan

MIS Manager

Angliss Singapore Pte Ltd

A member of Bidvest Asia Pacific Group

Mobile: 97839001

DID: 6770 4194

Tel: 6778 8787

Fax: 6770 4126

Email address: tan_jenny@angliss.com.sg<mailto:tan_jenny@angliss.com.sg>

Website: www.angliss.com.sg<http://www.angliss.com.sg/>

<http://www.angliss.asia/>

Re: hi,

Wed, 03 Jun 2015 08:37:02 GMT

Hi Siva,

I am not using Qlikview Server but Qlikview 9.0.

My settings are as follows :-

Best regards,

Jenny Tan

MIS Manager

Angliss Singapore Pte Ltd

A member of Bidvest Asia Pacific Group

Mobile: 97839001

DID: 6770 4194

Tel: 6778 8787

Fax: 6770 4126

Email address: tan_jenny@angliss.com.sg<mailto:tan_jenny@angliss.com.sg>

Website: www.angliss.com.sg<http://www.angliss.com.sg/>

<http://www.angliss.asia/>

Re: hi,

Siva_Sankar — Wed, 03 Jun 2015 08:59:40 GMT

May be your current selection returns only one row in your chart. use

ActiveDocument.ClearAll false

or upload your application

Re: hi,

Wed, 03 Jun 2015 09:15:26 GMT

Hi Siva,

I can see there are 200 rows in the chart and when I send to Excel, it is showing 200 rows.

Macro export to Excel is only showing 1 row.

Best regards,

Jenny Tan

MIS Manager

Angliss Singapore Pte Ltd

A member of Bidvest Asia Pacific Group

Mobile: 97839001

DID: 6770 4194

Tel: 6778 8787

Fax: 6770 4126

Email address: tan_jenny@angliss.com.sg<mailto:tan_jenny@angliss.com.sg>

Website: www.angliss.com.sg<http://www.angliss.com.sg/>

<http://www.angliss.asia/>

Re: hi,

Siva_Sankar — Wed, 03 Jun 2015 09:38:13 GMT

Your script is working fine. You configured the macro in trigger for ' on post reload'?

Re: hi,

Siva_Sankar — Wed, 03 Jun 2015 09:41:44 GMT

find the attached application.

Re: hi,

Wed, 03 Jun 2015 09:49:39 GMT

Yes, I did trigger macro on reload.

Best regards,

Jenny Tan

MIS Manager

Angliss Singapore Pte Ltd

A member of Bidvest Asia Pacific Group

Mobile: 97839001

DID: 6770 4194

Tel: 6778 8787

Fax: 6770 4126

Email address: tan_jenny@angliss.com.sg<mailto:tan_jenny@angliss.com.sg>

Website: www.angliss.com.sg<http://www.angliss.com.sg/>

<http://www.angliss.asia/>

Re: hi,

Wed, 03 Jun 2015 09:51:27 GMT

May I know where is the application?

Best regards,

Jenny Tan

MIS Manager

Angliss Singapore Pte Ltd

A member of Bidvest Asia Pacific Group

Mobile: 97839001

DID: 6770 4194

Tel: 6778 8787

Fax: 6770 4126

Email address: tan_jenny@angliss.com.sg<mailto:tan_jenny@angliss.com.sg>

Website: www.angliss.com.sg<http://www.angliss.com.sg/>

<http://www.angliss.asia/>

Re: hi,

Siva_Sankar — Wed, 03 Jun 2015 09:59:38 GMT

Attached. Are you checking via mobile?

Re: hi,

Siva_Sankar — Wed, 03 Jun 2015 10:00:26 GMT

Attached. Are you viewing thru mobile?

Re: hi,

Thu, 04 Jun 2015 06:45:29 GMT

Hi Siva,

Thanks. I got the attachment. Tested it but on reload, it does not pop up the message and also does not export the file into the said path. When I test the macro without reloading, it is popping up the message ‘done’ but no export to file path is done.

Best regards,

Jenny Tan

MIS Manager

Angliss Singapore Pte Ltd

A member of Bidvest Asia Pacific Group

Mobile: 97839001

DID: 6770 4194

Tel: 6778 8787

Fax: 6770 4126

Email address: tan_jenny@angliss.com.sg<mailto:tan_jenny@angliss.com.sg>

Website: www.angliss.com.sg<http://www.angliss.com.sg/>

<http://www.angliss.asia/>

Re: hi,

Siva_Sankar — Thu, 04 Jun 2015 08:04:30 GMT

Find the attachment. I have changed the code to create a excel and export the chart(previously it just copied the data in existing file). Forget the about the message, i just used for debugging. i removed it.

Re: hi,

Fri, 05 Jun 2015 02:14:55 GMT

Hi Siva,

Your application works but when I copied the macro into my application, it hits error on the clear all and when I commented the clear all, it encounters error on the next statement.

Please see attachment.

Best regards,

Jenny Tan

MIS Manager

Angliss Singapore Pte Ltd

A member of Bidvest Asia Pacific Group

Mobile: 97839001

DID: 6770 4194

Tel: 6778 8787

Fax: 6770 4126

Email address: tan_jenny@angliss.com.sg<mailto:tan_jenny@angliss.com.sg>

Website: www.angliss.com.sg<http://www.angliss.com.sg/>

<http://www.angliss.asia/>