NPrinting Condition

[christiana]

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

[#2 · Accepted solution]

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

[christiana]

Many thanks for your hint - it is working!

[cbaqir]

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

[#5]

correct

[cbaqir]

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.