Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'.
the format is the same, a date format
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.
thank you, what I need in this case is a formula that works for a filter in nprinting
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...