topic List box exclusions/data manipulation in QlikView

List box exclusions/data manipulation

Fri, 04 Dec 2015 18:00:30 GMT

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

Re: List box exclusions/data manipulation

swuehl — Fri, 04 Dec 2015 18:31:47 GMT

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

Re: List box exclusions/data manipulation

Fri, 04 Dec 2015 18:48:21 GMT

Thank you, that worked perfectly!