topic Re: Export to PPT in QlikView

Export to PPT

bhaskarsharma03 — Mon, 12 Mar 2018 04:18:19 GMT

Hi,

I need to export some objects to a PPT template in some pre-decided slides. Sometimes the charts need to be exported without any filter, and sometimes a filter will be applied before exporting the chart. For example,

1. The chart in attached QVW will go to slide 2 of the PPT template

2. The same chart for CustCode 'a' will go to slide 3

3. The same chart for CustCode 'b' will go the the slide 4... etc.

Could someone please help me with a script to achieve this?

Regards,

Bhaskar

Re: Export to PPT

kaushiknsolanki — Mon, 12 Mar 2018 04:58:00 GMT

Hi Bhaskar,

My honest suggestion will be you go for Qlik NPrinting. It has a capability to do what you want. Also it will help you to schedule those at a regular frequency.

This will also help you to manage everything with ease.

Regards,

Kaushik Solanki

Re: Export to PPT

yujiyamane — Mon, 12 Mar 2018 05:04:24 GMT

nPrinting would be the best option to achieve the requirment.

Re: Export to PPT

bhaskarsharma03 — Mon, 12 Mar 2018 05:08:01 GMT

We don't have NPrinting. Therefore, looking for the macro alternative.

Regards,

Bhaskar

Re: Export to PPT

yujiyamane — Mon, 12 Mar 2018 05:12:44 GMT

I see.

I did not know we can export PPT using macro.

I found some related pages as per below. Good luck.

Macro to generate PPT file (synchonization prob... | Qlik Community

Macro - Export PPT - Existing template - title name

https://community.qlik.com/docs/DOC-16418