Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

data fprmat problem

Dear Community,

I have field like this i need to convert into year format

based on that year i need to show comparative analysis

in that filed string also is there please advise the solution

 

2007-08

 

2008-09

 

2009-10

 

2010-11

 

2011-12

 

2012-13

 

Apr-10 to Apr-10

 

Apr-10 to Aug-10

 

Apr-10 to Dec-10

 

Apr-10 to Feb-11

 

Apr-10 to Jan-11

 

Apr-10 to Jul-10

 

Apr-10 to Jun-10

 

Apr-10 to May-10

 

Apr-10 to Nov-10

 

Apr-10 to Oct-10

 

Apr-10 to Sep-10

 

Apr-11 to Apr-11

 

Apr-11 to Aug-11

 

Apr-11 to Dec-11

 

Apr-11 to Feb-12

 

Apr-11 to Jan-12

 

Apr-11 to Jul-11

 

Apr-11 to Jun-11

 

Apr-11 to May-11

 

Apr-11 to Nov-11

 

Apr-11 to Oct-11

 

Apr-11 to Sep-11

 

Apr-12 to Apr-12

 

Apr-12 to Aug-12

 

Apr-12 to Dec-12

 

Apr-12 to Feb-13

 

Apr-12 to Jan-13

 

Apr-12 to Jul-12

 

Apr-12 to Jun-12

 

Apr-12 to May-12

 

Apr-12 to Nov-12

 

Apr-12 to Oct-12

 

Apr-12 to Sep-12

 

Apr-13 to Apr-13

 

Apr-13 to Jun-13

 

Apr-13 to May-13

 

Aug-10 to Jul-11

 

Aug-11 to Jul-12

 

Dec-09 to Nov-10

 

Dec-10 to Nov-11

 

Dec-11 to Nov-12

 

Feb-10 to Jan-11

 

Feb-11 to Jan-12

 

Feb-12 to Jan-13

 

Jan-10 to Dec-10

 

Jan-11 to Dec-11

 

Jan-12 to Dec-12

 

Jul-10 to Jun-11

 

Jul-11 to Jun-12

 

Jul-12 to Jun-13

 

Jun-10 to May-11

 

Jun-11 to May-12

 

Jun-12 to May-13

 

Mar-10 to Feb-11

 

Mar-11 to Feb-12

 

Mar-12 to Feb-13

 

May-10 to Apr-11

 

May-11 to Apr-12

 

May-12 to Apr-13

 

Nov-09 to Oct-10

 

Nov-10 to Oct-11

 

Nov-11 to Oct-12

 

Oct-09 to Sep-10

 

Oct-10 to Sep-11

 

Oct-11 to Sep-12

 

Sep-10 to Aug-11

 

Sep-11 to Aug-12

1 Reply
Not applicable
Author

Hi,

I see there are values that are 1 month period and others that are many months.

Does that data come from an Excel spreadsheet? In that case, I recommend you to clean it or make some kind of transformation before loading into QV.

If not, the solution could be a tricky (but not impossible) LOAD statement.