Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Sasi3557
New Contributor II

Data loading from hive

hi all

i have daily incremental data from hive, i need to load the present month and last month data in qvd with a condition as i dont have a date field i just have a year and month field.

condition:

if month(current date -15) = last month then load last month and present month data

else if month(current date -15) = current month load only current month data.

this should apply even if the year change happens. I am having issue with year change and this year is 2020 i had the script working till dec 2019. Please give a solution as soon as possible

 

thanks