topic Re: Exporting overlapping charts using macro in QV in QlikView

Exporting overlapping charts using macro in QV

Anonymous — Fri, 13 Oct 2017 11:02:22 GMT

I have a chart that is prepared by overlapping 2 different charts as one of the axis is hidden. for the user it appears as a single chart.

is there a way to export this as a single object. I have created macros in the past but they are exported using chart ids. has anyone come across a similar situation earlier?

I have attached chart that user sees.

Total Open -uses a different X axis that is hidden behind

Re: Exporting overlapping charts using macro in QV

marcus_sommer — Fri, 13 Oct 2017 14:53:19 GMT

I think it couldn't be done directly. By exporting them into xls/ppt you could use two exports and overlap them there like in qlikview. Another way might be to place (maybe additionally) on a separate sheet or within a report and to it as PDF - I remember to have read anywhere that earlier some PDF printer could be also print the content in a graphic-fileformat, maybe it's an alternatively.

- Marcus

Re: Exporting overlapping charts using macro in QV

Anonymous — Mon, 16 Oct 2017 06:19:25 GMT

Hi..I think I will need to use 2 exports like in xls/ppt then overlap it and then again convert it into pdf..thanks for your suggestions

Re: Exporting overlapping charts using macro in QV

qliksus — Mon, 16 Oct 2017 11:30:15 GMT

Are you exporting the objects to Excel ? If so then keep the object paste in the same cell and try

Activedoument.getsheetboject("CH01").copytocilpboard // Your main object

Objexcel.Rage("A1").select paste

Activedoument.getsheetboject("CH02").copytocilpboard // Your hidden object

Objexcel.Rage("A1").select paste

Re: Exporting overlapping charts using macro in QV

Anonymous — Tue, 07 Nov 2017 07:08:08 GMT

Hi Marcus

I exported the images into a ppt. then in ppt I have realigned the images and converted the ppt as a jpg.Your perspective was helpful and though I followed a different approach.