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.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
UserID2626
Creator II
Creator II

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

Hi

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