topic Re: Loading last digit in a string in QlikView

Loading last digit in a string

Wed, 09 Mar 2016 17:45:02 GMT

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

Thanks

Re: Loading last digit in a string

sunny_talwar — Wed, 09 Mar 2016 17:46:29 GMT

Try this:

Right(FieldName, 1) as Digit

Re: Loading last digit in a string

avinashelite — Wed, 09 Mar 2016 17:53:29 GMT

right(our_field_name,1)

Re: Loading last digit in a string

Wed, 09 Mar 2016 18:11:38 GMT

Sorry should have been far clearer as it's not always the last digit.

Basically I have the following :

2014-09

2014-10

2014-11

What I want is to always be left with the month so my results would show as such :

Re: Loading last digit in a string

manojkulkarni — Wed, 09 Mar 2016 18:15:42 GMT

you can use

right(FieldName,2) or subfield(FieldName,'-',2)

Re: Loading last digit in a string

maxgro — Wed, 09 Mar 2016 18:29:41 GMT

num(month(date#(yourfield, 'YYYY-MM')))

Re: Loading last digit in a string

sunny_talwar — Wed, 09 Mar 2016 18:53:23 GMT

Try this:

Num(Month(Date#(DateFieldName, 'YYYY-MM'))) as Month_Num

Re: Loading last digit in a string

Peter_Cammaert — Wed, 09 Mar 2016 20:45:20 GMT

or if you just want the month number and not the underlying date value:

num(right(fieldname,2),'#0')

[Edit] took out the whitespace to make it even smaller. That's about the only advantage: fewer characters to type

Re: Loading last digit in a string

amayuresh — Thu, 10 Mar 2016 07:07:23 GMT

Try this

=MID(FieldName,index(FieldName,'-')+1) as Month_Num

Re: Loading last digit in a string

jagan — Thu, 10 Mar 2016 07:12:32 GMT

Hi,

Try

Num(Right(FieldName, 2))

Hope this helps you.

Regards,

jagan.

Re: Loading last digit in a string

Anonymous — Thu, 10 Mar 2016 07:14:50 GMT

may be this as well?

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

Re: Loading last digit in a string

PrashantSangle — Thu, 10 Mar 2016 07:19:13 GMT

Hi,

try below

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

Regards,

Re: Loading last digit in a string

Chanty4u — Thu, 10 Mar 2016 07:26:07 GMT

try dis

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

Re: Loading last digit in a string

Chanty4u — Thu, 10 Mar 2016 07:32:06 GMT

or else

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

Re: Loading last digit in a string

sasiparupudi1 — Thu, 10 Mar 2016 08:18:47 GMT

Please try

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