Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
sathishkumar_go
Partner - Specialist
Partner - Specialist

Export into ppt

Hi All,

I have a requirement to export the qlikview chart in to PPT through macro and its working fine.

Now i am facing a issue, some of the charts are not aligned properly means if i have 1 million records in the chart then while exporting into PPT the chart has to be split and paste into PPT slides.

Looking forward your help and solution.

Thanks in advance.

Sathish

10 Replies
marcus_sommer

Hi Sathish,

I haven't a macro for that - you could look into APIGuide.qvw in your install-folder. There by search from "getrowcount" and similar in field member you will find examples which loop through objects on cell-level. Then you need a counter for your row-cluster and collect the field-values inside these cluster and use this for selections on these fields, make the export, remove the selection, collect the next row-cluster and so on - but you will need some effort to bring these approach to work + by your amount of data and exports it will be rather (too ?) slow ...

I think the other both solutions - creating the row-cluster within in the sript or using a prepared master-ppt which have a changing data-source (through full-export into xls(x) or csv) - will be easier and faster.

Generall by your amount of reports ( and I assume you will have some more as that) you should consider if ppt is a suitable format and if you could use tools for that, publisher, nprinting or othe third-party-tools.

- Marcus