Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
avantime
Creator II
Creator II

Macro to cycle through months and export charts to excel in order

Hi,

I need a macro to cycle through all months and export 3 charts on one excel sheet for each month.

Right now I have what you can see in the attached app.

The problem is that the sheets in the generated Excel workbook are not in order (Jan 2018, Feb 2018, ....) and that not all months are being exported.

Hope I made myself clear.

1 Solution

Accepted Solutions
tamilarasu
Champion
Champion

Hello Catalin,

Have a look at the attached file. Have a nice day.

Capture.PNG

View solution in original post

3 Replies
avantime
Creator II
Creator II
Author

Anyone?

tamilarasu
Champion
Champion

Hello Catalin,

Have a look at the attached file. Have a nice day.

Capture.PNG

avantime
Creator II
Creator II
Author

Thank you very much Tamil! Just what I needed.

Have a nice day!