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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
lmit
Creator II
Creator II

[resolved] to filter rows having specifyword

Hi all,
i have a requirement like i need to filter data based on few words in string instead of full word 
Below is how my data looks
s.no|name
1|a
2|b
3|123R
4|1R23
i need data which is having the letter R in the last,which means i need 3rd record but 4th should not come. I tried tfilterrow but i couldn't achieve it.I will always get the letter in the last only(Like 123R) and i need to declare this filter condition in context variable 
Do anyone suggest any other method or process

Thanks in advance
lmit

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable

Hi,

I will always get the letter in the last only(Like 123R) and i need to declare this filter condition in context variable

Have you tried to use method Java String.endsWith() in advanced mode of tFilterRow?
Best regards
Sabrina




0683p000009MGap.png

View solution in original post

1 Reply
Anonymous
Not applicable

Hi,

I will always get the letter in the last only(Like 123R) and i need to declare this filter condition in context variable

Have you tried to use method Java String.endsWith() in advanced mode of tFilterRow?
Best regards
Sabrina




0683p000009MGap.png