Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

last three digits from particular code

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 ?

6 Replies
Anonymous
Not applicable
Author

qlikitem.png

Anil_Babu_Samineni

May be this?

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
mostwanted123
Creator
Creator

Hi Saksham,

Try this,

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

Regards,

Pratik

Kushal_Chawda

simple solution could be

LOAD ...

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

its_anandrjs

Try one of this

=Right([item hd name], 3)


OR


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

OR

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

its_anandrjs

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;