How do you create a filter for a date field to bri... - Qlik Community

Anonymous · ‎2016-09-29

I am attempting to create a report that will just pull in the sales orders generated on the previous business day. Attached is the filter I used in NPrinting. The result when I run the preview is that I see all of the dates. I attached the filter to the table and still get the result. I changed up the number in the field and I still get all dates. What am I doing wrong? Thanks for the help as I am new to NPrinting.

Nicole-Smith · ‎2016-09-29

Your filter is looking for anything less than today, not just the previous day.

You may need something like this:

Value: =date(today()-1)

Check the "Evaluate" box.

Anonymous · ‎2016-10-19

Thank you, that worked!

Anonymous · ‎2016-10-19

Also, while I have you. Sorry for being a newbie, but what would the expression look like if I always wanted to include everything within the last 30 days of todays date?

Nicole-Smith · ‎2016-10-19

Set your value to:

=YourDateField>=date(today()-30)

Do not check "IsNumeric" or "Evaluate".

How do you create a filter for a date field to bring in items for only just last business day?