topic Re: Using Filters on NPrinting in Qlik NPrinting

Using Filters on NPrinting

Gabo77 — Wed, 18 May 2022 16:46:05 GMT

Hi guys.

We have a manufacturing plant that has 2 productions lines (L1, L2).

We need to create a report that has 2 graphics:

1. Productions per hour

2. Compliance

I build 2 graphis on Qlik Sense and it shows perfectly the values.

This grafics are builded using the same table data

For the first graphic, we need to display the Production per Hour for two lines, but for Compliance graphic we need to show only the data for L2.

I suposed that we can add a filter on Apps > Filters setting to this filter the value of "L2", then applying that filter to the "Report" and finally using it only in the Image for the "Compliance" graphic on the "Template Editor" but... the filter are aplyed on the 2 graphics... so, in the 2 grafics we only see the graphics for L2... How can we set the template to acchive this?

Re: Using Filters on NPrinting

Frank_S — Wed, 18 May 2022 17:54:51 GMT

@Gabo77

I think you might be able to achieve your requirement by using table object filters. For details visit Applying a filter to an object

create your NP filters
apply the necessary filter directly on the table (or image) object as needed within the template editor

Hope this helps...

Re: Using Filters on NPrinting

Gabo77 — Wed, 18 May 2022 18:29:15 GMT

Hi Frank_S, thanks for your support...

I think im doing as you say... but with the difference that im applying the filter to the "Report" on the NP too... i omit this last one and it works but... when i open the report, it shows a "blank" image where the L1 report for "Compliance" were placed early... is there a way to omit that page??

Regards!

Re: Using Filters on NPrinting

Frank_S — Wed, 18 May 2022 19:01:07 GMT

Unfortunately out of the box, a specific page cannot be ignored when invalid selections appear.

However, perhaps you can leverage NPrinting conditions.

For example, if your condition is configured where 'if chart is empty, false' the report is sent.

In this case, where the chart is empty, the report will not be sent. However the entire report will not be sent.

This method will likely require that you build more than one report and apply your condition either to the report or to the task (if you choose to place two or more reports within the same publish task.

Condition Rule

Condition on Report in the Publish Task

If needed, Condition on the Publish task via the "Conditions" button shown above rather than on the "Reports" button.

So in a nutshell, use conditions to send a reports ( where table contain data), Any of the reports in the task that do not meet the condition ie: empty chart, will not be delivered.

You may need to experiment with different combinations of rules, condition placement and addition of additional (similar) reports before you get the result you need.

Hopefully this or some iteration of it work for you.

For more information about configuring NPrinting 'Conditions' feel free to visit help pages Conditions.

Kind regards...

Re: Using Filters on NPrinting

Frank_S — Wed, 18 May 2022 19:12:44 GMT

One more thing,

If you have only one chart in your report, then you can prevent the report from being delivered, you can select the following option in your NP report.

Error handling: select "Do not generate report" option

Re: Using Filters on NPrinting

Gabo77 — Wed, 18 May 2022 20:09:37 GMT

Hi Frank_S Thanks for your support... even when my issue are not solved (not easily as i would have liked) i marked this as a solution because you gave me a way to do more tests.

So grateful.

Regards!

Re: Using Filters on NPrinting

Frank_S — Wed, 18 May 2022 21:45:15 GMT

Hi @Gabo77

Glad I could assist.
Kind regards...