Qlik Community

New to Qlik Sense

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

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
bandarjm
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

concatenate

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

Store CurrQVD

Labels (1)
1 Reply
Prashant_N
Contributor III
Contributor III

Hi,

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,

Prashant