Skip to main content
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. READ MORE

Filter for last 90 days of data in Qlik Replicate part two

100% helpful (1/1)
Showing results for 
Search instead for 
Did you mean: 
Former Employee
Former Employee

Filter for last 90 days of data in Qlik Replicate part two

Last Update:

Sep 13, 2022 7:26:31 AM

Updated By:


Created date:

Sep 12, 2022 2:54:48 PM

This is an extension to Filter for last 90 days of data in Qlik Replicate. This article outlines how to set up a filter for the past 90 days worth of data via a full load pass thru filter or a record selection condition.



You run a task with a 90-day full load pass thru filter enabled. If you have 'TRUNCATE before load' or 'DROP and CREATE table' enabled (Task Settings-> Full load -> Full Load Settings -> Target Table Preparation), only the data in range will be transferred.

Once the full load completes, it continues to move forward with CDC. Let's say a few months go by and now your target table is not reflecting the last 90 days' worth of data. It is the original 3-month window plus inserts, updates and deletes since the last full load.

How do you limit the task to data within a specific range?

Below is an option workaround to this scenario.


Define your time periods and enforce them with record level conditions for CDC changes.

Postgres Source example where today's date is 9/12/22:




CREATE TABLE public.filtertest (id INT PRIMARY KEY, first_name VARCHAR(40), created_at TIMESTAMP);

INSERT INTO public.filtertest VALUES(1,'Kelly','2022-02-07 10:00:00');
INSERT INTO public.filtertest VALUES(2,'Laura','2022-01-07 10:00:00');
INSERT INTO public.filtertest VALUES(3,'Blair','2022-09-07 10:00:00');
INSERT INTO public.filtertest VALUES(4,'Liz','2022-08-07 10:00:00');
INSERT INTO public.filtertest VALUES(5,'Maddie','2022-07-14 10:00:00');
INSERT INTO public.filtertest VALUES(6,'Jordan','2022-03-14 10:00:00');


where Filter conditions are:




Plain text:

$created_at < '2022-09-12 10:00:00' AND $created_at > '2022-06-14 10:00:00'

created_at > current_date - interval '90' day


For the full load, only records with ID 3, 4,and 5 will apply on the target.



UPDATE public.filtertest SET first_name = 'LARRY' WHERE id = 2;

Will not apply the change.

UPDATE public.filtertest SET first_name = 'LARRY' WHERE id = 4;

Will apply the change.





The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

Related Content


Original Article 

Labels (2)
Version history
Last update:
‎2022-09-13 07:26 AM
Updated by: