topic Re: Two conditions in an NPrinting filter in Qlik NPrinting

Two conditions in an NPrinting filter

LuisReco — Mon, 26 Jan 2026 11:41:11 GMT

Dear experts,

I am applying this filter in NPrinting that works ok:

=if(month(Today())=1 ,Year(AddYears(Today(),-1)),Year(Today()))

But I would like apply an improvement with another condition like this:

=if(month(Today())=1 and day(today()) < 15,Year(AddYears(Today(),-1)),Year(Today()))

It's a pity but it doesn't work.

Is it possible have two diferent conditions. If not (as I think), Do you have any suggestion?

Thank you in advance.

Best regards,

Re: Two conditions in an NPrinting filter

rubenmarin — Mon, 26 Jan 2026 19:56:58 GMT

Hi, I don't know why that doesn't work, if it's an evaluation that returns a single value it should work.

There are different ways to set the filters, one easy change for this case could be using DayNumberOfYear() like: =If(DayNumberOfYear(Today())<15,Year(AddYears(Today(),-1)),Year(Today()))

Re: Two conditions in an NPrinting filter

Digvijay_Singh — Mon, 26 Jan 2026 22:25:45 GMT

Can you share where exactly you are trying this, it worked okay in the qlik app -

Re: Two conditions in an NPrinting filter

Lech_Miszkiewicz — Mon, 26 Jan 2026 22:35:24 GMT

Hi @LuisReco

Filters usually don't work because they are not applied correctly. Things you must consider are:

data type of the filed you are trying to filter:
filter type (Value, Numerical Value, Evaluate Value, Advanced Search)
are there other filters also applied which could affect result of the expression you are trying to do.

I wrote about many pitfalls when using NPrinting filters on below posts so you may want to check if any of those applies to your case.

Having multiple conditions in IF() statement will work if the filter is applied properly.

Lastly - you are running very old and no longer supported NPrinting (as you are indicating May 2021 SR4). Are you running compatible Qlik Sense version with it - meaning it is is on the compatible list? https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/DeployingQVNprinting/System-requirements_engine.htm

Re: Two conditions in an NPrinting filter

LuisReco — Sat, 31 Jan 2026 18:22:55 GMT

Thank you Ruben. Finally both (yours and mine) worked. I made a mistake with the field to be evaluated in Nprinting.