Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Kohli
Creator II
Creator II

Change the date format

   I have one field name with Experience. How can covert into  year month format, like 2.1

          

                Experience

          2 year 1 months 10 days

          1 year 7 months 15 days

          2 year 1 months 10 days

          2 year 1 months 10 days

         4 year 1 months 10 days

         1 year 1 months 10 days

         4 year 1 months 10 days

         2 year 1 months 10 days

         5 year 1 months 10 days

         3 year 1 months 10 days

         3 year 1 months 10 days

         4 year 1 months 10 days

         3 year 1 months 10 days  ;


O/P like:

           Exp

           2.1

           1.7

            2.1

            2.1

            4.1

            1.1

            4.1

         

5 Replies
jomar_ebonite
Partner - Contributor III
Partner - Contributor III

Hi,

Try this

Right ( Trim ( Exp ) , 1 ) & Mid( Trim ( Exp ) , 6 , 1 )

jomar_ebonite
Partner - Contributor III
Partner - Contributor III

Right ( Trim ( Exp ) , 1 ) & '.' &  Mid( Trim ( Exp ) , 6 , 1 )

raju_insights
Partner - Creator III
Partner - Creator III

=Subfield(Experience,'year',1)&'.'&Subfield(Subfield(Experience,'month',1),'year',-1)

Øystein_Kolsrud
Employee
Employee

Here's my suggestion:

SubField(Experience,' ',1) & '.' & SubField(Experience,' ',3)

Øystein_Kolsrud
Employee
Employee

Ouch! I was a couple of minutes too slow