Qlik Replicate: Setting up Filter using SQL lite expression

[dineshkumarl]

Hi All,

I am trying to load Today-1 data for a table from Oracle.

Option1: 

Using data and time function filter in Qlik Replicate

1. Click on the table 

2. Navigate to Filter > click on Expression Builder

3. $columnname=date('now', '-1 days')

I do get the resulted date as previous date when I test the expression. 

However, when I run the task, I do not see any data flow. I kept the task running for 10mins, 30mins, 1hour and 2hours period but didn't observe any data flow. 

Option 2: 

Defining the above function in Transform

1. click on the tale

2. Navigate to Transform option

3. Select the date column where we want to apply the filter and click on 'fx' option

4. In expression builder type date('now', '-1 days') and test it

5. Able to get previous date as result. 

I do observe data flow but the filter condition doesn't work. I say data from other days as well rather than for the previous date. 

Kindly let me know where I am going wrong in this. Appreciate any assistance towards the same. 

Thanks

[john_wang · Accepted solution]

Hello @dineshkumarl ,

Thanks for reaching out to Qlik Community.

Please check the sample full load pass thru filter, in the sample it's 90 days, hope it helps.

Regards,

John.

[dineshkumarl]

Thank you for the update. The full load pass through filter works. 
We would have to specific the condition as per source DB. For oracle I have specified trunc(SYSDATE)-1.

It works as expected. 

Cheers!

[john_wang]

Thank you so much for the feedback @dineshkumarl !