Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
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

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

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

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

Anyone?

Highlighted

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

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

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

Thank you very much Tamil! Just what I needed.

Have a nice day!