Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

List box exclusions/data manipulation

I have a list of Questions, in field 'Question'.  I want to create a list box that will only show two of the specified questions, "Group: Productivity" and "Self: Productivity".  I'd like to be able to just have these two questions listed as possible selections, and at the same time, change the text to read just "Group" and "Self".

Are either of these solutions possible?

Thanks,

Tim

1 Solution

Accepted Solutions
swuehl
MVP
MVP

In your list box, try an expression as field (last item <expression> in the field drop down list):

=If( Match( Question, 'Group: Productivity','Self: Productivity'), Subfield(Question,':',1) )

View solution in original post

2 Replies
swuehl
MVP
MVP

In your list box, try an expression as field (last item <expression> in the field drop down list):

=If( Match( Question, 'Group: Productivity','Self: Productivity'), Subfield(Question,':',1) )

Not applicable
Author

Thank you, that worked perfectly!