Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
dineshkumarl
Partner - Creator
Partner - Creator

Qlik Replicate: Setting up Filter using SQL lite expression

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

Labels (3)
1 Solution

Accepted Solutions
john_wang
Support
Support

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.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!

View solution in original post

3 Replies
john_wang
Support
Support

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.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
dineshkumarl
Partner - Creator
Partner - Creator
Author

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
Support
Support

Thank you so much for the feedback @dineshkumarl !

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!