One of my filters I use in NPrinting does not work. Either the table that should be produced is absent (very wrong expression I guess) or the table is present, but this one filter has not been applied.
I try to set the filter with the "evaluate" option. I tried a lot of different expressions, but none of them is working.
The table in QlikView (12.20.20400.0)
The table on which the filter should apply is a table with just 4 values, all dates. 3 of them are loaded from an excel-file, one (the one I'm trying to filter) is generated from the script bij the statement vLastPreviousMonthDay=Date(MonthEnd(Today(),-1),'DD-MM-YYYY') and then added tot the table with $(vLastPreviousMonthDay)
The filter in NPrinting (February 2018 SR1)
I use three filters in NPrinting to generate the table. Two of them are of the type "Value is" or "Numeric value is" and work correctly. This specific filter should be dynamic, to always present the data filtered by the last day of the previous month. So I use "Evaluate value" with (at first) the same expression as the script in QlikView that generated this date.
I tried these expressions, all with no luck:
and all above with Now() instead of Today(). I noticed that the expressions with "Text(" will return the table, but not with te filter applied. The Num() versions leave the produced table absent (so that's not the way!)
When I just say "numeric value is" and then "31-03-2018" as the expression, the filter is set correctly. (but it doesn't work with "value is" instead of "numeric value is"). So: somehow the expression is incorrect?
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.