Qlik Community

New to Qlik Sense

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

Tell us which business and trade publications you read most regularly: RESPOND NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Incremental load previous 3 months

Need help where i am going wrong. correct me!!!

Need to load last 3 months incremental load . I will check daily and load previous 3 months data. 

should work for 2020 ,2021.,,

Condition i have is

let v3month=month (today())-3

Select * from table where year=VCurrrentYear and Month >= v3month


Select * from CurrQVD where year=VCurrrentYear and Month <v3month

Store CurrQVD

Labels (1)
1 Reply
Contributor III
Contributor III


Script looks ok.

please check the format you specified for month & year is same as present in the database.

If same then apply floor() on both the variables data.

Thanks & Regards,