topic Re: last three digits from particular code in QlikView

last three digits from particular code

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all

I want to extract last three digits(ie 100 as given in figure) from the following (item hd name) marked in red in the image . what will be the expression for the same and where to write that expression ?

Re: last three digits from particular code

Anonymous — Wed, 13 Sep 2017 06:02:43 GMT

Re: last three digits from particular code

Anil_Babu_Samineni — Wed, 13 Sep 2017 06:58:55 GMT

May be this?

SubField([item hd name], ' ', -1)

Re: last three digits from particular code

mostwanted123 — Wed, 13 Sep 2017 06:59:58 GMT

Hi Saksham,

Try this,

right([item hd name],3) as [item hd name]

Regards,

Pratik

Re: last three digits from particular code

Kushal_Chawda — Wed, 13 Sep 2017 07:02:35 GMT

simple solution could be

LOAD ...

right([item hd name],3) as NewField

Re: last three digits from particular code

its_anandrjs — Wed, 13 Sep 2017 07:03:31 GMT

Try one of this

=Right([item hd name], 3)

=Subfield([item hd name], ' ',-1)

=Subfield([item hd name], ' ',1)

Re: last three digits from particular code

its_anandrjs — Wed, 13 Sep 2017 07:21:09 GMT

Or may be you can try this for

Load

Right([item hd name], 3) as OptionOne,

NUM(Right([item hd name], 3)) as OptionTwo

From Source;