topic Re: How to filter a Nprinting Report for a Dimension when combinations with some months bring no data? in Qlik NPrinting

How to filter a Nprinting Report for a Dimension when combinations with some months bring no data?

Anonymous — Wed, 25 Sep 2019 18:40:54 GMT

Hi all.

Let's try explain my issue.

I have a qlikview dinamic table chart, with this setup:

Dimensions: Code Supervisor, Salesman, Month, Product.
Expressions: Goal, Total Value, %

Supervisor and Salesman are normal dimensions. Product and Month are transposed columns (about 15 new columns for each month)

I have a NPrinting report too, wich should be generated on that chart, where each supervisor needs receive only their Salesmans.

The recipients are the supervisors, and filters was created for each one with their codes (Code Supervisor on chart).

This report have a filter on it, called "Date Process" where is set 2 fields: Year = {2017} and Month = [no value]

This table looks very extense in width (about 540 columns) and then i have on the NPrinting excel report each month separated per tab.

So far, so good.

When i run the NPrinting task, i have this scenario:

Recipients with filters of code supervisor
Report with 1 filter "Date Process"

For those supervisors who have Sales every month, the report was generated as expected, but for those where have lack of data for some months, the report is generated for all Salesman, because the set of applied filters brings "no data" and then all filters are cleared.

I thinked in one workaround. Make one chart for each month in set analysis, but i don't think this is an elegant solution.

Someone see another solution?

Re: How to filter a Nprinting Report for a Dimension when combinations with some months bring no data?

Stephen_Jasionowski — Wed, 17 Jan 2018 17:13:04 GMT

Do you have 'Verify filter' selected in the filter parameters?

See the bottom of this document: How to Create Static and Dynamic Filters Based on Fields

Re: How to filter a Nprinting Report for a Dimension when combinations with some months bring no data?

Anonymous — Wed, 17 Jan 2018 17:22:59 GMT

Yes. I tried things explained in another 3 topics in this community.

The behavior of NPrinting using Verify Filter is that: When the filter is evaluated and he founds "no data" in January per example, a production of the report for that filter is stopped, and the excel file contain only January tab, with all Salesmans data.

The others topics i read to look for solution was these below, but no one of them help with this

Re: How to filter a Nprinting Report for a Dimension when combinations with some months bring no data?

Anonymous — Wed, 07 Feb 2018 13:49:23 GMT

I founded a solution.

I had to load the recipients with a new column for filter lock purposes.

When I import the filters and put the Lock option on filter parameters, in the Code Supervisor field, the report is generated correctly for every salesman.

By the way, this topic: Filter Syntax, Parameters, and Options for Importing Recipients help me with sintax to use.