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: 
Not applicable

Export to PDF

Hi ALL

I am trying to export a table with data to PDF. However, it is not exporting just the current sheet.

Kindly advise how to export all.

Rgds

Bharati

1 Solution

Accepted Solutions
rittermd
Master
Master

Export to PDF will only export what you can see on the screen. 

If you want all of the data in a table then you need to choose export data when you right click on the table object.

You also can Export to PDF the entire sheet.  But again it will only show you whatever you are currently looking at.

There may be an extension that does something different.  But not sure.

View solution in original post

9 Replies
rupamjyotidas
Specialist
Specialist

Are you trying to export ONE table or all Graphs and Tables??

rittermd
Master
Master

Export to PDF will only export what you can see on the screen. 

If you want all of the data in a table then you need to choose export data when you right click on the table object.

You also can Export to PDF the entire sheet.  But again it will only show you whatever you are currently looking at.

There may be an extension that does something different.  But not sure.

Not applicable
Author

Entire sheet

Not applicable
Author

Thank you for your reply!

Yes i tried Export data and this work fine but we want to export entire sheet in PDF so that it is read-only.

shraddha_g
Partner - Master III
Partner - Master III

Exporting in PDF will only take screenshot of chart and convert it into PDF. It won't export whole data.\

In that case you can export in Excel and convert it into PDF.

Not applicable
Author

Hi Bharati,

Export PDF steps as below:

Step1: Create a document report.

Step2 : Create a Action of Text Box and pass Document Report ID to export to PDF

Thanks,

Nitin

Not applicable
Author

Qlik Branch has few options.  One of them is Qlik Branch

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Hi ,

Try this code:

SUB Export

set sObject1 = ActiveDocument.GetSheetObject("CH09")

sObject1.Export "E:\QlikView\Data\Testing\Report.Pdf", ", "

end sub

By using this macro u can store any where u want and u can save file which format u want .

I hope this may helps you.

-Nagarjun

Not applicable
Author

Hi

thank you for your reply.

Please advise where to put this code.

SUB Export

set sObject1 = ActiveDocument.GetSheetObject("CH09")

sObject1.Export "E:\QlikView\Data\Testing\Report.Pdf", ", "

end sub

Rgds

Bharati