Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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!