topic Re: Re-evaluate filters in NPrinting in Qlik NPrinting

Re-evaluate filters in NPrinting

talita_verdes — Wed, 21 Jun 2017 01:16:03 GMT

Good Evening!

I have a Power Point report in NPrinting where I have the following settings:

1. Select the maximum of the year and month loaded in the Qlikview of each State.
2. Generate reports by Country and State.

Imagine that I have the following table:

Country	State	Max Date (DD/MM/YYYY)
Brazil	Minas Gerais	01/01/2017
Brazil	São Paulo	01/04/2017
Brazil	Rio de Janeiro	01/06/2017

In NPrinting I made a dynamic filter for the date, and I inserted the State field into the Cycle.

My problem is:
The report it generates is only from Rio de Janeiro - Brazil. I need NPrinting to re-evaluate the date for all States.

How can I do this?

Thanks

Re: Re-evaluate filters in NPrinting

Lech_Miszkiewicz — Wed, 21 Jun 2017 07:48:02 GMT

Hi Talita,

I am always trying to simplify filters in nPrinting by putting a logic to Qlik.

What i would do in this case is create a Key build of Country&State&Date and i would flag keys with Maximum Date for each combination with 1 and for another I would put 0

see example script:

Fact:

Load

Country,

State,

Date

Resident

SomeTable

;

Left Join (Fact)

LOAD

Country,

State,

Max(Date) as Date,

1 as MyFlag

Resident

Fact

Group by

Country,

State

;

Then in NPrinting i would have static filter selecting only MyFlag = 1

regards

Lech

Re: Re-evaluate filters in NPrinting

Lech_Miszkiewicz — Wed, 21 Jun 2017 07:57:03 GMT

There should be a small adjustment to my formula as you only need a monthly buckets..

therefore i would change Date to MonthStart(Date)

like this

Fact:

Load

Country,

State,

MonthStart(Date) as Date

Resident

SomeTable

;

Left Join (Fact)

LOAD

Country,

State,

Max(MonthStart(Date)) as Date,

1 as MyFlag

Resident

Fact

Group by

Country,

State

;

Re: Re-evaluate filters in NPrinting

avinashelite — Wed, 21 Jun 2017 08:00:16 GMT

Where you have implemented the dynamic date filter ? in the report level or Task level ?

it needs to be in the report level ...and check the expression your using

Re: Re-evaluate filters in NPrinting

talita_verdes — Wed, 21 Jun 2017 17:44:21 GMT

Hi Avinash!

I tested with the dynamic filter in the report, but it didn't work.

The expressions used are:

Year: =Year(Max(DATE))

Month: =Text(Month(Max(DATE)))

Re: Re-evaluate filters in NPrinting

Lech_Miszkiewicz — Thu, 22 Jun 2017 00:30:30 GMT

this is already confusing.

how do you know that month is actualy a text?

Month in general is a dual value which can be either 1 or Jan , 2 or Feb etc...

When you put "Text" function ahead of your formula you must be 100% sure your Month field in datamodel is a string/text

still

i strongly advice you to consider flagging your records as i have described above

Re: Re-evaluate filters in NPrinting

talita_verdes — Thu, 29 Jun 2017 19:32:01 GMT

Good Afternon!

I found the solution.

I created a trigger in the State field that selects the maximum year and month when selections occur in the State field.

Thanks

Re: Re-evaluate filters in NPrinting

Lech_Miszkiewicz — Thu, 29 Jun 2017 22:09:30 GMT

Hi Talita,

great news!!

bad news is that triggers are not supported and as much as it works for you for unknown reasons they may stop working.

regards

Lech

https://help.qlik.com/en-US/nprinting/June2017/Content/GettingStarted/HowCreateConnections/Create-Connections.htm

Unsupported QlikView documents

Before you create a connection to a QlikView document, ensure that the QlikView document does not use any of the following:

alternate states
sheet and document triggers
Always one selected list box property

Qlik NPrinting cannot modify or remove these options. As a result, Qlik NPrinting may not have access to the enitre dataset of the connected QlikView document during the cache generation process, and while generating reports.

QlikView documents that use these features, are not supported by Qlik NPrinting.