Date range in NPrinting 19

[Vittore8]

Hi, please tell me how I can get a date range and apply this range in the filter

[miguelbraga]

Hi there Vittore8,

It can be done by creating a filter and selecting Advanced Search and then in the formula, just add something like this:

=[YourDate] >=$(vStartData) and [YourDate] <=$(vEndData)

Note: You must define the two variables ("vStartData" and "vEndData") in the app prior. After creating those variables you'll need to rebuild the metadata in Connections.

Hope it helps.

Kind regards,

MB

[Vittore8]

I have a variable in the click that is equal to 5, when I enter it by name, I do not write the Value value and then it returns an error can not be null

why do I need to enter Value? If I have a variable that can be defined as Max (Date) for example and here's how to work with it?

[miguelbraga]

The error occurrs because you're using a filter that have no value and there for cannot be calculated. This will lead to a report generation failure when publishing a task. 

Can I ask you what is the specific version of NPrinting you're using? There might be restrains in some versions that isn't present in the later versions of NPrinting, for example the Advanced Search. It seems you have a earlier version which has less features in it. Can you confirm your version so we can help you with your task?

Kind regards,

MB

[Vittore8]

19.40.3.0

[miguelbraga]

You must create variable inside the Qlik Sense app, then reload Metadata to use in the Advanced Search.