Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
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
MVP
MVP

Re: List box exclusions/data manipulation

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
MVP
MVP

Re: List box exclusions/data manipulation

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

Not applicable

Re: List box exclusions/data manipulation

Thank you, that worked perfectly!