Filter condition not supporting ?

[ashmitp869]

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]

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

Read more on filters here: https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/ReportsDevelopment/Static-dynamic-fi...

[Lech_Miszkiewicz · Accepted solution]

@Vegar @ashmitp869 

"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

https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/ReportsDevelopment/Static-dynamic-fi...

I discuss filtering options on my blog here: 

https://nprintingadventures.com/category/nprinting/filters/

cheers

Lech

[Lech_Miszkiewicz]

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:

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