topic Re: Unable to select date range in NPrinting in Qlik NPrinting

Unable to select date range in NPrinting

Anonymous — Fri, 29 Jun 2018 08:49:47 GMT

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

Re: Unable to select date range in NPrinting

Daniel_Jenkins — Wed, 04 Jul 2018 00:00:26 GMT

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:

Date filters in nPrinting 17

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.

Re: Unable to select date range in NPrinting

Lech_Miszkiewicz — Wed, 04 Jul 2018 03:43:17 GMT

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