Discussion Board for collaboration on QlikView Integration.
i have years like this
01/01/2009 12:00:00 AM
01/01/2010 12:00:00 AM
01/01/2011 12:00:00 AM
now i want to swap only years in date field .. for 2009 i want 2010 and for 2010 i want 2009 and for 2011 i want 2009 ..
how to do that in qlikview script by using if else condition ?
Please have a loot at below articles:
How to Use Simple Date Functions in QlikView and Qlik Sense | EzDataMunch
calendar year to fiscal year - Qlik Community - 1253798
Date and time functions ‒ QlikView
View solution in original post