topic Re: NPrinting Condition in Qlik NPrinting

NPrinting Condition

christiana — Thu, 03 Mar 2016 16:31:28 GMT

Hi,

I would like to run a report only when I have an intersection of two fields. Meaning, the report shall run for example only if we have sold a product in the previous month. If the product hasn't been sold the report shall not run or give 0.

Currently if I'm doing the selection MonthYear = February 2016 and Product = A and we did not sell it in February 2016 but in January 2016, then the selection of the MonthYear is cleared out and the report is displaying the result of all periods in which we have sold product A. What can I do, in order to tell NPrinting that the report shall only run when product A is sold in February 2016?

I suppose that I need to setup a variable in QV but so far I'm without ideas what / how to do.

Many thanks for your help.

Christiana

Re: NPrinting Condition

Thu, 03 Mar 2016 17:31:19 GMT

NPrinting 16 has a feature called "verify filter".

This is a parameter you set in the filter and can be set on import.

If you select verify filter, then if there is no intersection for the filters with verify filter set, the report will not be sent.

There's a tutorial about NPrinting 16 filters here:

How to Create Static and Dynamic Filters Based on Fields

Best

Aran

Re: NPrinting Condition

christiana — Fri, 04 Mar 2016 15:53:36 GMT

Many thanks for your hint - it is working!

Re: NPrinting Condition

cbaqir — Mon, 24 Jul 2017 13:56:34 GMT

Aran,

Is verify filter also the option that should be used when you are uusing paging in an excel doc but you don't want a blank tab?

More info:

Nprinting 16 Conditions | Qlik Community

Re: NPrinting Condition

Mon, 24 Jul 2017 14:14:03 GMT

correct

Re: NPrinting Condition

cbaqir — Mon, 24 Jul 2017 14:18:09 GMT

In this case, my filter is a variable: vRCIDefectOutliers and I am trying to only show the tab via paging if vRCIDefectOutliers >0. I'm having trouble finding a way to make it work.