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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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))