topic Re: Nprint issue in Qlik Automate

Nprint issue

RobMazaheri — Fri, 27 Feb 2026 21:02:38 GMT

Hi I am using Nrpint for some data but I cannot seem to get the filter to select the lastest weekending date

i've tried lots of options on co pilot but nothing works

for example in advance search

=REPORTING_WEEK=Max(REPORTING_WEEK)

=REPORTING_WEEK = Max({1} TOTAL Aggr(If(Len(Trim(REPORTING_WEEK))>0, REPORTING_WEEK), REPORTING_WEEK))

=Max({1} TOTAL Aggr(If(Len(Trim(REPORTING_WEEK))>0, REPORTING_WEEK), REPORTING_WEEK))

none of these work

hope someone can help

Re: Nprint issue

Vegar — Mon, 02 Mar 2026 06:02:54 GMT

Could it be that your field is a dual, and that you are dking a string comparison between the string value and the numeric that is returned from using max(REPORTING_WEEK)?

It's been a while since I used NPrinting, but I believe you should be able to state that you want to do comparisons on the numeri(or evaluated) value. Alternatively, force your expression to return a string, maybe by using maxstring(REPORTING_WEEK) instead.

Re: Nprint issue

Lech_Miszkiewicz — Mon, 02 Mar 2026 09:01:54 GMT

Many issues here:

what is the datatype of the Reporting_Week field
to use formula you need to change type of filter from "Value is" to either "Evaluate value" or "Advanced Search"
Depending on the type of the field you need to make sure your formula returns such type. It is critical to understand that duals are numerical values with possible symbol representation and in NPrinting we need to pass numerical value of it.

I wrote quite a few posts about this and I strongly encourage you to read about it to get an understanding of the issue rather than trying to guess:

https://nprintingadventures.com/2019/02/15/the-pitfalls-of-nprinting-filters-part-1-dates-and-duals/

https://nprintingadventures.com/2022/03/19/filters-in-nprinting-how-hard-can-it-be-part-3-evaluate-value/

https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/

https://nprintingadventures.com/2024/11/29/advanced-search-filter-trap/

cheers