Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Greater than timestamp and date condition check not working in qlik sense script


In load script i have to load greater than lastly loaded date and between three days.

I tried with many cases but not working

Load * where

Num(timestamp ($(exe_dt)))> Num(timestamp ($(last_exe_dt))) and dt<=$(max_dt) and dt>=$(min_dt);Sql  select Statement;

$(Max_dt) is today() date;$(Min_dt) is today()-3

Please help to solve this i tried by giving mostly all possible timestamp and date formats.

0 Replies