Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Not applicable

Conditional PDF Generation from a Report using Publisher

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

7 Replies
danielrozental
Honored Contributor II

Re: Conditional PDF Generation from a Report using Publisher

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.

Not applicable

Re: Conditional PDF Generation from a Report using Publisher

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

danielrozental
Honored Contributor II

Re: Conditional PDF Generation from a Report using Publisher

User list is in the QVW file.

Not applicable

Re: Conditional PDF Generation from a Report using Publisher

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.

danielrozental
Honored Contributor II

Re: Conditional PDF Generation from a Report using Publisher

Just use the loop field in document function to distribute.

Not applicable

Re: Conditional PDF Generation from a Report using Publisher

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".

Not applicable

Re: Conditional PDF Generation from a Report using Publisher

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.

Community Browser