Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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
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,
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
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
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
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
Thanks Frank,
I will update the macro you have previously did and test the new one.
I will inform you of the result.
Regards,
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.
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,
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,