Qlik Community

Ask a Question

QlikView Integrations

Discussion Board for collaboration on QlikView Integration.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Creator
Creator

swap years in qlikview

Hi 

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 ?

 

any help 

 

Labels (2)
1 Solution

Accepted Solutions
PadmaPriya
Support
Support

Hello @capriconuser 

 

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

 

Thanks,
Padma Priya

Qlik Support

We are just 'like' you and like to be liked when providing a helpful answer. You may press the 'Solution Accepted' button if an answer provided solves your issue.

View solution in original post

1 Reply
PadmaPriya
Support
Support

Hello @capriconuser 

 

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

 

Thanks,
Padma Priya

Qlik Support

We are just 'like' you and like to be liked when providing a helpful answer. You may press the 'Solution Accepted' button if an answer provided solves your issue.

View solution in original post