Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Vittore8
Creator
Creator

Date range in NPrinting 19

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

Labels (1)
5 Replies
miguelbraga
Partner - Specialist III
Partner - Specialist III

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
Creator
Creator
Author

Vittore8_0-1599565799454.png

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
Partner - Specialist III
Partner - Specialist III

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
Creator
Creator
Author

19.40.3.0

miguelbraga
Partner - Specialist III
Partner - Specialist III

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