topic Re: Select in Field action in QlikView

Select in Field action

Wed, 25 Nov 2020 16:16:04 GMT

I have a parameter (Items) containing the following values:

Apple, Orange, Table, Chair, Banana, Kiwi, Pen

I want to add a button + an action that that will select all those values except for Table and Chair.

Can someone please help with how I can achieve that? If at all possible?

Thanks,

Amit

sunny_talwar — Fri, 09 Sep 2016 13:43:23 GMT

May be this as the search string

("Apple"|"Orange"|"Banana"|"Kiwi"|"Pen")

Fri, 09 Sep 2016 13:46:12 GMT

I know this can be done but I was looking for something more generic in cases where I have a long list and I need to exclude only a few.

Fri, 09 Sep 2016 13:47:11 GMT

I think I found the answer

Basically it's 2 actions and the order is important.

Select in Field - Items

(Table|Chair)

Select Excluded - Items

Does anyone else have any better suggestions?

stigchel — Fri, 09 Sep 2016 13:48:24 GMT

use for search expression

='('&Concat({<Items=-{'Table','Chair'}>} DISTINCT Items,'|')&')'

stigchel — Fri, 09 Sep 2016 13:50:53 GMT

Example attached

sunny_talwar — Fri, 09 Sep 2016 13:51:31 GMT

Look at stigchel‌'s response

Fri, 09 Sep 2016 13:55:02 GMT

Hi,

You have to add "select in field" to button actions.

Your field should be "Items" and search string will be (Apple|Orange|Banana|Kiwi|Pen).

Hope it helps!

Fri, 09 Sep 2016 13:59:03 GMT

Thank you!!!!

stigchel — Fri, 09 Sep 2016 14:03:50 GMT

You're welcome