Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We have the need to filter a Nprinting report for a previously established date range (for example 02/15/2018 to 03/20/2018). Our intention is that under the initial and final date we can filter the report.
It is being tested with the option "Evaluate Value" and the filter would be as in the attached image. Do you know how we could generate the filter correctly?
Mensaje editado por: Jaime Martin Martin
Hi Jaime,
As of version June 2018, NPrinting 17.x does not (yet) have options to filter based on Variables, Bookmarks and Advanced Search (which is what you are trying to do). I have no idea if/when this will be introduced. There have been several threads in these forums offering workarounds that may work for you. Examples:
and
How to set up a filter "Last X days" in NPrinting?
Just to be clear, you can use variables in your Field filters but you cannot have purely variable filters like we could in NPrinting 16. For example if you have a variable:
vMaxMonth =Month(Now())
You can use it in a Field filter (assuming you have a field called Month) like this:
HTH - Daniel.
Hi,
so you are doing one BIG mistake there by using > (greater) or < (less) than....
Evaluated value needs to resolve to single value - in your case there can be multiple values possible and therefore it will not work
See this topic in official help document:
"Dynamic filters use QlikView or Qlik Sense formulas. Formulas must use QlikView or Qlik Sense rules and syntax, and return a single value. Formulas are evaluated, and the results are used to filter data. You do not have to modify dynamic filters to gain new values.
"
https://help.qlik.com/en-US/nprinting/June2018/Content/ReportsDevelopment/Static-dynamic-filters.htm
My suggestion is to flag records in calendar which are falling in between dates from your filter and use it as a filter in NPrinitng
or....
Workaround:
Daniels seggestion lead me to next thought. You could have 2 data island fields with dates. Single selection on the field(s) could drive a variable(s).
Field A ...with dates driving variable A and field B .... with dates driving variable B
Let variableA = Only(FieldA);
Let variableB = Only(FieldB);
Each of those variables could be used in Qlik Set analysis like this:
Sum( {< yourDateField={">=$(variableA)<=$(variableB)"} > } SalesAmount)
Then you could apply 2 filters in NPrinitng on: 1 filter on FieldA filtering "dateFRom" and filter on FieldB filtering "date To"
cheers
Lech