Cannot filter Nprinting report by date

[aguirre]

I cannot filter by date my report linked to a QLik Sense Dashbord

The filter has date_1 = today()

Failed generation of report -- for user -----. ERROR: Cannot apply filter Filters: [Fields: [Name: F\date_1 , ConnectionId: 65129c2c-386c-49c1-8c48-4fecd54acb52, Values: [String:=today()], Override: False, Void: False, SelectExcluded: False], Variables: [], Void: False], Bookmark: , Void: False to current document d  

date_1 is a date filed and in the QLik Sense has YYYY-MM-DD (Tag is $numeric $integer $timestamp $date)

What could be wrong?

[Lech_Miszkiewicz · Accepted solution]

Hi @aguirre 

its in front of you in the error: [String:=today()]

That indicates to me you are using "Value is" option of the filter which as documented very well in documentation is only for strings: https://help.qlik.com/en-US/nprinting/February2025/Content/NPrinting/ReportsDevelopment/Static-dynam...

Instead you should use "Evaluate value" option:

cheers