Hi all. I am really new to Qlik so any help or suggestions would be helpful. I am working on an incremental load script that uses SQL and I want to put in some conditional WHERE clauses in my SQL. I found this snippet below which works great, but I want to expand on this if possible
//Use alt() function to make sure the variable always has a value (avoiding null problem)
Let vQvdCreatedTime = alt(QvdCreateTime('lib://$(vQVDCommonFolder)/E_fact_tender_current.QVD'),0);
if vQvdCreatedTime > 0 then
trace File Exists!;
trace File Does not Exist!;
I want to create a new variable using an if statement.