topic Re: Date filtering in reporting in Reporting Service & Alerting

Date filtering in reporting

Zerker — Tue, 21 Apr 2026 19:54:08 GMT

I am trying to set up a 2 qlik report filters one that filters to the last month. And one that filters to the previous year. The expressions i try in the actual app works, but not in the reporting filter.

Prior year

=[Repair Date]>=(AddMonths(Today(),-12))

for this one when i just do = and no > it will bring back data from current date from last year

Previous month

MonthStart(Date([Invoice Month])) = MonthStart(AddMonths(Today(), -1))

Re: Date filtering in reporting

Andrea_Bertazzo — Thu, 23 Apr 2026 10:18:24 GMT

hi @Zerker

If you need to filter the last year, you can use something like this:
Year([Repair Date]) = Year(Today()) - 1

If you need to filter the latest 12 months, the formula seems fine, but there may be incompatibilities related the the format of the [Repair Date] filed.
Maybe you can force it to a date format:
=Date([Repair Date])>= Date((AddMonths(Today(),-12)))

Re: Date filtering in reporting

Zerker — Thu, 23 Apr 2026 15:10:27 GMT

Neither one worked. Below is the format of my date field

Re: Date filtering in reporting

Lech_Miszkiewicz — Tue, 28 Apr 2026 23:47:03 GMT

Hi @Zerker

Your screenshot is showing mask in which your field is loaded. You need to screenshot us more details in there (tags) which would indicate if field is actually loaded as date (and therefore can be filtered as date) or maybe an asci text and cannot. This is critical to for the filter to be properly configured.

Also, have you selected search option?

I have created test app and applied your filter and it works on my end so you may need to either double check your syntax or make sure you follow the steps provided above to check what is not working. Another thing is whether or not you are applying any other filters? They may be affecting search string by data association!

Cheers

Lech