Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
P_qlik
Partner - Contributor III
Partner - Contributor III

filter from a specific date

Hi,

I need to do a date filter starting from feb 2019 until today, I tried to do something like this but it doesn't work

date>1/02/20

how can I do?

Thank you

Labels (1)
5 Replies
Or
MVP
MVP

From the date field's search box, e.g. >01/02/2019. Note that the format of the date entered should match the format of your document's date, and your actual values should be dates rather than the string 'feb 2019'.

 

P_qlik
Partner - Contributor III
Partner - Contributor III
Author

the format is the same, a date format

Or
MVP
MVP

As long as the field is a date field (not strings that happen to be formatted as dates), and you use the correct format, Qlik should filter it this way.

Or_0-1616079041274.png

 

P_qlik
Partner - Contributor III
Partner - Contributor III
Author

thank you, what I need in this case is a formula that works for a filter in nprinting

Or
MVP
MVP

Same thing should work with NPrinting, but date filters in NPrinting are really finicky about the whole dual() aspect of dates. It often takes some trial and error to get the right format...