Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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.