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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to pick the values

Hi All,

I am having following values in my table

nonprod@@@hydenwer

nonprod@@@hjanflsnlinhlslg

nonprod@@@bsjkgbjkbjksbgjbkks

From above I need pick the values only which is coming after "@" symbol

-Jay

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

subfield(MyFieldHere, '@', -1)


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

subfield(MyFieldHere, '@', -1)


talk is cheap, supply exceeds demand
MK_QSL
MVP
MVP

=SubField(values,'@@@',-1)