topic Re: Filter condition not supporting ? in Qlik NPrinting

Filter condition not supporting ?

ashmitp869 — Thu, 30 Sep 2021 02:01:29 GMT

Hi there ,

Please kindly assist , how to use the filters in nprinting.

My reports need to show data until

Reporting Date <=Max([Reporting Date],7) so I am trying to use filter in nprinting but it look like its nor supporting.

Vegar — Thu, 30 Sep 2021 04:54:46 GMT

max() returns a number, try changing from 'Value is' to 'Numeric Value is'

Lech_Miszkiewicz — Thu, 30 Sep 2021 05:10:13 GMT

"Value" and "Numerical Value" do not take expressions! So they will not work in this case.

If you wish to use expression like Max() or anything else you need to use: Evaluate value or Advanced Search options

I discuss filtering options on my blog here:

cheers

Lech

Lech_Miszkiewicz — Thu, 30 Sep 2021 05:24:17 GMT

one more comment...

your requirement is to filter Reporting Date <=Max([Reporting Date],7)

in this case the only option is to use "Advanced search" as "Evaluate" only expects a single ( = ) value and not range of values ( <= )

I have written about Advanced search here: