https://community.qlik.com/t5/App-Development/Data-loading-from-hive/m-p/1665571#M63613 <P>hi all</P><P>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.</P><P>condition:</P><P>if month(current date -15) = last month then load last month and present month data</P><P>else if month(current date -15) = current month load only current month data.</P><P>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</P><P>&nbsp;</P><P>thanks</P> Sat, 16 Nov 2024 19:18:10 GMT Sasi3557 2024-11-16T19:18:10Z https://community.qlik.com/t5/App-Development/Data-loading-from-hive/m-p/1665571#M63613 <P>hi all</P><P>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.</P><P>condition:</P><P>if month(current date -15) = last month then load last month and present month data</P><P>else if month(current date -15) = current month load only current month data.</P><P>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</P><P>&nbsp;</P><P>thanks</P> Sat, 16 Nov 2024 19:18:10 GMT https://community.qlik.com/t5/App-Development/Data-loading-from-hive/m-p/1665571#M63613 Sasi3557 2024-11-16T19:18:10Z