How to exclude 0 values in NPrinting reports.

[MuraliPrasath]

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

[sampada0810]

Hi Murali,

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

Un-check  Include Nulls checkbox.

[MuraliPrasath]

Hi,

Thanks for your reply.

I don't see Include check box in QlikView.

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

[prma7799]

Please find the attached 

[MuraliPrasath]

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

[Lech_Miszkiewicz]

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

[MuraliPrasath]

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.

[Ruggero_Piccoli]

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.