dynamically save various reports as pdf with different filename

[#1]

Dear All,

I am trying to automatically save various reports as pdf.  Reports should have different file name.  May i kindly ask how to do it in qlikview.

I appreciate your help.

Regards,

[Frank_Hartmann]

Ok here you go.

If you only want to loop through certain sheets then you will have to setup one more Variable in Qlikview,

vShow=1, then you will have to set the conditional view in the QV sheets to vShow=1 but not for the sheets from which you want to export the charts. Leave coditional view for these sheets blank

Then I just added a piece of code in module to set this variable to 0 when Export starts and to 1 when Export ends!

See this example. there are 5 Sheets, but when export starts 3 of them get hidden

[#3]

Thanks Frank.

I will try the solution and let you know.

Furthermore, may I kindly ask you to please remove in your attached  sample the sheets that shows the company logo.

I appreciate your usual support.

Regards,

[#4]

Frank,

Reference to creating the required variable to loop from specific sheet

Please refer to one of the macros that you have posted here in this thread  and if I may ask  if it is possible for you to write a code that select only the sheets as defined in the macro thus eliminating the need to add a variable (vShow=1).

Example .... ActiveDocument.Sheets("Sheet1").Activate

           ActiveDocument.Sheets("Sheet2").Activate

           ActiveDocument.Sheets("Sheet3").Activate

Thanks

[#5]

Hello Frank,

Just want to know if you have read my last post re: instead of creating variables to loop into various sheet, is it possible to define the sheets in macro as per below example

Example .... ActiveDocument.Sheets("Sheet1").Activate

           ActiveDocument.Sheets("Sheet2").Activate

           ActiveDocument.Sheets("Sheet3").Activate

I appreciate if you could give your advise / updated macro.

thanks

[#6]

Hello Frank,

Just want to know if you have read my last post re: instead of creating variables to loop into various sheet, is it possible to define the sheets in macro as per below example

Example .... ActiveDocument.Sheets("Sheet1").Activate

           ActiveDocument.Sheets("Sheet2").Activate

           ActiveDocument.Sheets("Sheet3").Activate

I appreciate if you could give your advise / updated macro.

thanks

[Frank_Hartmann]

Sorry for my late response.

see attached txt file. This macro will only select SH29, SH30, SH31 and ignores all other sheets.

I marked the codeline so that you are able to replace them with yourSheetIDs.

hope that helps

[#8]

Thanks Frank,

I will update the macro you have previously did and test the new one.

I will inform you of the result.

Regards,

[#9]

Dear Frank,

I trust all is well.  Tested the macro, please note that it only reads the first business group. doesn't move from sheet to sheet and does not save the file.

I appreciate if you could take a look and help.

[#10]

Good morning Frank,

Fixed. Your macro works perfectly well.  In one of the sheet I am using, there is a "clear all" command when sheet is activated (under trigger) tab.

Removed that and the result is as expected.

Thank you so much for your help.

Regards,

[#11]

Hi Frank,

I have one more question.

Going back to my sample qlikview file and initial requirement, now is it possible to save all reports in one file, having each company in different section in power point.

      Slides 1-4 showing the summary (year only)

      Slides 5-8 - showing the same template but for company 1

       Slides 9-12 - showing the same template but for company 2

        Slides 13-16 - showing the same template but for company 3

then save the report. (as one file name combining slides 1-16)

Regards,