topic Conditional PDF Generation from a Report using Publisher in QlikView

Conditional PDF Generation from a Report using Publisher

Mon, 26 Jan 2026 18:19:17 GMT

From a report report created within QlikView, using the QlikView publisher it can be generated as pdf using QEMC.

However as an example if a Table in the report has no data, we do not want to generate the PDF and send it to users. We only want to generate the PDF if there is data in some table.

Please advise how this could be achieved.

Regards,

Santosh

Re: Conditional PDF Generation from a Report using Publisher

danielrozental — Fri, 24 Aug 2012 19:32:35 GMT

Santosh, we faced a similar situation and what we did is we removed users that did not had any data from the field in the application that had the users to send the reports to.

Hope that helps.

Re: Conditional PDF Generation from a Report using Publisher

Tue, 28 Aug 2012 09:51:53 GMT

Thanks Daniel for the response. Your solution should help us. Could you please clarify on the below to apply this solution

- How is the user list controlled, is it through section access?.

- If not, please advise how the user list is configured in Management Console?

Rajendra

Re: Conditional PDF Generation from a Report using Publisher

danielrozental — Tue, 28 Aug 2012 12:23:07 GMT

User list is in the QVW file.

Re: Conditional PDF Generation from a Report using Publisher

Tue, 28 Aug 2012 13:02:31 GMT

Thanks again Daniel,

Could you please elaborate further on this. How the user list is loaded and then the same list is associated in the distribution list in QEMC. In our case, the users for whom the pdf is generated are not part of the data.

Re: Conditional PDF Generation from a Report using Publisher

danielrozental — Tue, 28 Aug 2012 13:08:10 GMT

Just use the loop field in document function to distribute.

Re: Conditional PDF Generation from a Report using Publisher

Tue, 28 Aug 2012 15:56:57 GMT

Daniel,

Below are steps followed:

In the qvw file:

1. Created an inline table with user_name and email_id columns (in lower case)

2. This table would get populated based on the condition (currently records are available for use in loop and distribute). That is if this table is empty, non of the users will be provided with the pdf.

Now on QEMC, the settings are as below:

1. Distribute->Loop Field in Document->Loop and Distribute
           Field containing recipient information: 'email_id'
           Check user identity on: EmailAddress
2. Destination->Target type: E-mail is checked
3. FileType -> Output Document Type -> PDF report from source document: selected 'Report name create in qvw file'
4. Notify-> Notification E-mail -> Send notification e-mail to recipients is checked.

Is there any step which I am missing as the pdf are not generated with the Loop Field in Document option

As per the log below is the warning: email id assigned in the inline table is a valid one.

Warning: Dynamic distribution returned no recipients using "EmailAddress" using parameter "UserEmailID".

Re: Conditional PDF Generation from a Report using Publisher

Tue, 28 Aug 2012 16:45:32 GMT

I believe the solution is now working, As the distribution was of a different task which was reloading the data again was clearing the user list from the inline table. Thereby, pdf files were not generated.

Thanks for your help. You response was very helpful in resolving the issue.