topic Re: filter from a specific date in Visualization and Usability

filter from a specific date

P_qlik — Thu, 18 Mar 2021 14:17:25 GMT

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

Re: filter from a specific date

Or — Thu, 18 Mar 2021 14:25:48 GMT

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'.

Re: filter from a specific date

P_qlik — Thu, 18 Mar 2021 14:29:05 GMT

the format is the same, a date format

Re: filter from a specific date

Or — Thu, 18 Mar 2021 14:50:59 GMT

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.

Re: filter from a specific date

P_qlik — Thu, 18 Mar 2021 14:52:48 GMT

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

Re: filter from a specific date

Or — Thu, 18 Mar 2021 14:55:52 GMT

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...