Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to maintain two years of data

Hi all,

I have to maintain two fiscal years of data in qvd(current year and previous year).fiscal year start at nov and at oct month.

suppose data in database is available from nov -2013 then data in qvd should from nov-13 to till date for two fiscal year. once two fiscal years completed( i.e nov-2013 to oct-2014,nov-2014 to oct-2015) then nov-2013 to oct-2014 data should be deleted and it should store data of nov-2014 to oct-2015 and data from current running year.

please suggest solution

Thanks in advance....

0 Replies