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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Making a selection from variable using subfield

I have a variable in which I would like to make a selection using subfield function.  I'm using the action Select in Field and in the search string I use subfield(variable name,',',variable number).

My variable is a list of field names within quotes.  Example: 'name1','name2','name3', etc

The quotes create the issue.  I can get the right name with the subfield but theSelect in Field wont work. Is there another function that would strip away the quotes?

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Sorry everyone - just figured it out.  The use of purgechar

purgechar(subfield(variable name,',',variable number),chr(39))

View solution in original post

1 Reply
Anonymous
Not applicable
Author

Sorry everyone - just figured it out.  The use of purgechar

purgechar(subfield(variable name,',',variable number),chr(39))