Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Aubry
Contributor III
Contributor III

How to filter the dates for the last month in Qlik Nprinting

Hi all,
I have a problem with date filtering.

I would like to filter the dates for the last month,

Aubry_0-1651825425481.png

 

but I got an error message:

Aubry_1-1651825452069.png

thank you for your helps
regards

Aubry M

 

Labels (2)
4 Solutions

Accepted Solutions
Ruggero_Piccoli
Support
Support

Hi,

I suggest you start by searching for similar conversations here in the community. For example:

Then evaluate to use Advanced Search Creating a dynamic filter with advanced search, my suggestion is to create the same selection in Qlik Sense and be sure it is working correctly there before using it in a Qlik NPrinting filter.

I hope this helps.

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

Frank_S
Support
Support

I agree with Ruggero to use the Advanced Search filter tool to handle operators in your function and to test it in Qlik Sense. This type of filter is built specifically to handle those.

Try also removing the comma from the formula. 

ie: <MonthStart(today()-1) not  <MonthStart(today(),-1) 

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

Aubry
Contributor III
Contributor III
Author

Hello Ruggero,

Thank you for your answer, I have read and taken your advice into account.

I have attached a screenshot of my test.
it doesn't work when i put : today()

Aubry_0-1652279825317.png

 

 

I do not understand

View solution in original post

Aubry
Contributor III
Contributor III
Author

Hello Frank,

thank you for your advice (coma) 
I just posted more of my different tests

have a good after noon
Aubry

View solution in original post

4 Replies
Ruggero_Piccoli
Support
Support

Hi,

I suggest you start by searching for similar conversations here in the community. For example:

Then evaluate to use Advanced Search Creating a dynamic filter with advanced search, my suggestion is to create the same selection in Qlik Sense and be sure it is working correctly there before using it in a Qlik NPrinting filter.

I hope this helps.

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
Frank_S
Support
Support

I agree with Ruggero to use the Advanced Search filter tool to handle operators in your function and to test it in Qlik Sense. This type of filter is built specifically to handle those.

Try also removing the comma from the formula. 

ie: <MonthStart(today()-1) not  <MonthStart(today(),-1) 

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Aubry
Contributor III
Contributor III
Author

Hello Ruggero,

Thank you for your answer, I have read and taken your advice into account.

I have attached a screenshot of my test.
it doesn't work when i put : today()

Aubry_0-1652279825317.png

 

 

I do not understand

Aubry
Contributor III
Contributor III
Author

Hello Frank,

thank you for your advice (coma) 
I just posted more of my different tests

have a good after noon
Aubry