topic Re: How to exclude 0 values in NPrinting reports. in Qlik NPrinting

How to exclude 0 values in NPrinting reports.

MuraliPrasath — Tue, 20 Nov 2018 11:37:51 GMT

Hi,

I've a NPrinting report that has following table. Example:- if my report runs every month then if any Employee sales is '0' then that employee row should not to shown. How to achieve this?

Employee, Sales,

Ram, 0

Raj, 253

Gopi, 201

Hari, 542

Re: How to exclude 0 values in NPrinting reports.

sampada0810 — Tue, 20 Nov 2018 18:14:44 GMT

Hi Murali,

You can restrict the data at the QlikView/ Qlik Sense side only.

Un-check Include Nulls checkbox.

Re: How to exclude 0 values in NPrinting reports.

MuraliPrasath — Thu, 22 Nov 2018 09:02:14 GMT

Hi,

Thanks for your reply.

I don't see Include check box in QlikView.

I'm using QlikView 12 version. Nprinting 15 version.

Re: How to exclude 0 values in NPrinting reports.

prma7799 — Thu, 22 Nov 2018 09:24:42 GMT

Please find the attached

Re: How to exclude 0 values in NPrinting reports.

MuraliPrasath — Thu, 22 Nov 2018 12:51:16 GMT

I got this, but still no luck in the NPrinting side of it. Still, NPrinting is not excluding the 0s rows.

Re: How to exclude 0 values in NPrinting reports.

Lech_Miszkiewicz — Thu, 22 Nov 2018 21:36:16 GMT

Above answers are correct if you use Qlik Table as a sole source of data in your report also as a table. It may not work if you use Level with some field in it.

What is your template? Can you share screenshot of your template with all entities expanded?

cheers

Lech

Re: How to exclude 0 values in NPrinting reports.

MuraliPrasath — Fri, 23 Nov 2018 08:28:47 GMT

Hi Lech,
Thanks for your reply. Yes, My Template has levels for SubTotals. I can't able to exclude 0 values in subtotal levels(Client Name).

Please see the screenShot.

Re: How to exclude 0 values in NPrinting reports.

Ruggero_Piccoli — Fri, 23 Nov 2018 09:24:06 GMT

Hi,

Insert the straight table with the data rows in the Levels node instead of the field.

The field has all values, also the ones that has 0 in the data. The table has not that values in the rows so they will not be exported in the report.

Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.