I have two fields AcctYear and AcctMonth on the DB2 source table. how can i put a filter to get only last 3 months data in Qlik relicate/enterprise

sivanathp — Mon, 29 Dec 2025 21:28:10 GMT

I have two fields AcctYear and AcctMonth on the DB2 source table.

how can i put a filter to get only last 3 months data in Qlik relicate/enterprie manager. I do not want last 90 days. I need last 3 months data only

Re: I have two fields AcctYear and AcctMonth on the DB2 source table. how can i put a filter to get only last 3 months data in Qlik relicate/enterpris

john_wang — Tue, 30 Dec 2025 01:07:25 GMT

Hello @sivanathp ,

There’s a helpful article that explains how to use this kind of filter:

https://community.qlik.com/t5/Official-Support-Articles/Filter-for-last-90-days-of-data-in-Qlik-Replicate/ta-p/1880761

In the example, the date range is specified as '-90 Day'. You can simply replace that with '-3 Month' if that better matches your requirement.

Good luck.

Regards,

John.

topic Re: I have two fields AcctYear and AcctMonth on the DB2 source table. how can i put a filter to get only last 3 months data in Qlik relicate/enterpris in Qlik Replicate

I have two fields AcctYear and AcctMonth on the DB2 source table. how can i put a filter to get only last 3 months data in Qlik relicate/enterprise

Re: I have two fields AcctYear and AcctMonth on the DB2 source table. how can i put a filter to get only last 3 months data in Qlik relicate/enterpris