Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
MuraliPrasath
Creator III
Creator III

How to keep only the last two text?

For Example:

From [Consumer Q1]    I need only the  [Q1]

         [Sales Q1]          I need only the [Q1]

     [Customer Q2]        I need only the [Q1]

I need only the last two digits!!

Need Help!!

Labels (1)
1 Solution

Accepted Solutions
swuehl
Champion III
Champion III

Right( YourField, 2)

View solution in original post

3 Replies
anbu1984
Master III
Master III

Subfield(TxtField,' ',-1)

swuehl
Champion III
Champion III

Right( YourField, 2)

Anonymous
Not applicable

What swuehl said is correct try right(YourField, 2)