Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
sanjyotpatkar
Creator III
Creator III

Exporting overlapping charts using macro in QV

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

1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

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

View solution in original post

4 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

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

View solution in original post

sanjyotpatkar
Creator III
Creator III
Author

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

qliksus
Specialist II
Specialist II

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

sanjyotpatkar
Creator III
Creator III
Author

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.