Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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))