Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

devarasu07
Honored Contributor II

NPrint sending email with no data in report?

Hi All

We have a report, which is running & output distributing via email on weekly basis and it's working fine. the issue here is when there is no data in the report & it just sent empty template via email. actually we don't want it to send out the email if there is no data.

What i've tried is below,

I've enabled "verify filter" check box option at Nprinting report, but still i'm getting the empty results reports via email.


Capture.JPG

Note: I'm using Qlikview Nprinting 16.3.0

Hi Stephen, below URL link not working.

http://community.vizubi.com/knowledgebase/articles/261146-how-to-control-report-generation-with-cond...

Thanks,
Deva

2 Replies
mkelemen
Contributor III

Re: NPrint sending email with no data in report?

Hi Deva,

here is

How to Control Report Generation with Conditions

I think that your problem is that the result is not empty but it has one line.

Checking "Suppress when value is null" on your dimensions might help.

BR,

  Matus

Lech_Miszkiewicz
Honored Contributor III

Re: NPrint sending email with no data in report?

Devarasu has probably a measure which returns text "A Stocks" in one of his columns.

You would have to put conditions on that expression to ensure that it returns "nothing" when other numbers are = 0 or null().

cheers

Lech

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
Community Browser