Re: Loading last digit in a string - Page 2 - Qlik Community

Report Inappropriate Content · ‎2016-03-09

Hi how would I load '2015-08' so that only '8' is displayed ?

Thanks

Anonymous · ‎2016-03-10

may be this as well?

=mid(FieldName, len(FieldName)-1, len(FieldName))

PrashantSangle · ‎2016-03-10

Hi,

try below

num(SubField(F1,'-',-1))

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Chanty4u · ‎2016-03-10

try dis

= mid(field, Index(field,'&',-2)+1)

Chanty4u · ‎2016-03-10

or else

subfield([Source field], '-', -2) as [Destination field]

sasiparupudi1 · ‎2016-03-10

Please try

date(date#(x,'YYYY-MM'),'M')