Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Honored Contributor

Re: Export to PDF

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.

9 Replies
rupamjyotidas
Valued Contributor

Re: Export to PDF

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

rittermd
Honored Contributor

Re: Export to PDF

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

Re: Export to PDF

Entire sheet

Not applicable

Re: Export to PDF

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
Honored Contributor III

Re: Export to PDF

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

Re: Export to PDF

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

Re: Export to PDF

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

nagarjuna_kotha
Valued Contributor II

Re: Export to PDF

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

Re: Export to PDF

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