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]

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

[john_wang]

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

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.