Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Hello Catalin,

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

Capture.PNG

View solution in original post

3 Replies
Highlighted
Creator II
Creator II

Anyone?

Highlighted

Hello Catalin,

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

Capture.PNG

View solution in original post

Highlighted
Creator II
Creator II

Thank you very much Tamil! Just what I needed.

Have a nice day!